postgreSQL pb 2
juste une autre question, j'ai reinstalle postgresql, et la y un
nouveau truc que je capte pas vraiment :
[ lam : root ] apt-get install postgresql-contrib
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
postgresql postgresql-client
The following NEW packages will be installed:
postgresql postgresql-client postgresql-contrib
0 packages upgraded, 3 newly installed, 0 to remove and 3 not upgraded.
Need to get 1936kB of archives. After unpacking 5407kB will be used.
Do you want to continue? [Y/n] y
Get:1 http://non-us.debian.org testing/non-US/main postgresql-client 7.1.3-4 [267kB]
Get:2 http://non-us.debian.org testing/non-US/main postgresql 7.1.3-4 [1451kB] Get:3 http://non-us.debian.org testing/non-US/main postgresql-contrib 7.1.3-4 [218kB]
Fetched 1936kB in 36s (52.5kB/s)
Selecting previously deselected package postgresql-client.
(Reading database ... 52376 files and directories currently installed.)
Unpacking postgresql-client (from .../postgresql-client_7.1.3-4_i386.deb) ...
Selecting previously deselected package postgresql.
Unpacking postgresql (from .../postgresql_7.1.3-4_i386.deb) ...
Although you have no existing database files in the standard locations,
you have a postgresql directory at /usr/lib/postgresql
To protect executables that you may need for dumping an older
database, they are being moved to /usr/lib/postgresql/dumpall/unknown
Selecting previously deselected package postgresql-contrib.
Unpacking postgresql-contrib (from .../postgresql-contrib_7.1.3-4_i386.deb) ...
Setting up postgresql-client (7.1.3-4) ...
The file /etc/postgresql/postgresql.env provides the normal set-up for
an ordinary user running PostgreSQL. It is automatically read by the
wrapper script for PostgreSQL user commands in postgresql-client.
Setting up postgresql (7.1.3-4) ...
Updating /var/lib/postgres/.profile ...
PostgreSQL databases can be created with any one of a number of
different character encodings. Please choose the default encoding, which
will be used for all newly-created databases in the absence of a specific
encoding specification. The choices are:
SQL_ASCII ASCII
EUC_JP Japanese EUC
EUC_CN Chinese EUC
EUC_KR Korean EUC
EUC_TW Taiwan EUC
UNICODE Unicode(UTF-8)
MULE_INTERNAL Mule internal
LATIN1 ISO 8859-1 English and some European languages
LATIN2 ISO 8859-2 English and some European languages
LATIN3 ISO 8859-3 English and some European languages
LATIN4 ISO 8859-4 English and some European languages
LATIN5 ISO 8859-5 English and some European languages
KOI8 KOI8-R
WIN Windows CP1251
ALT Windows CP866
Enter default encoding (SQL_ASCII):
You need to specify the locale under which the postmaster will run.
(This mainly affects the sorting of text. Use of any locale but C
will reduce the efficiency of index access; however, it will also
force sorting by ASCII code rather than by national collating order.)
You have the following locales enabled in your system:
en_US
Select locale [C]:
Now installing the PostgreSQL database files in /var/lib/postgres/data
su - postgres -c cd /var/lib/postgres; . ./.profile; LANG=C initdb --encoding SQL_ASCII --pgdata /var/lib/postgres/data
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.
Fixing permissions on existing directory /var/lib/postgres/data
Creating directory /var/lib/postgres/data/base
Creating directory /var/lib/postgres/data/global
Creating directory /var/lib/postgres/data/pg_xlog
Creating template1 database in /var/lib/postgres/data/base/1
DEBUG: database system was shut down at 2001-10-17 11:02:42 CEST
DEBUG: CheckPoint record at (0, 8)
DEBUG: Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 16384
DEBUG: database system is in production state
Creating global relations in /var/lib/postgres/data/global
DEBUG: database system was shut down at 2001-10-17 11:02:43 CEST
DEBUG: CheckPoint record at (0, 108)
DEBUG: Redo record at (0, 108); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 17199
DEBUG: database system is in production state
Initializing pg_shadow.
Enabling unlimited row width for system tables.
Creating system views.
Loading pg_description.
Setting lastsysoid.
Vacuuming database.
Copying template1 to template0.
Success. You can now start the database server using:
/usr/lib/postgresql/bin/postmaster -D /var/lib/postgres/data
or
/usr/lib/postgresql/bin/pg_ctl -D /var/lib/postgres/data -l logfile start
PostgreSQL database now installed.
Use /usr/bin/createdb to create a specific database and
/usr/bin/createuser to enable other users to connect to a
PostgreSQL database.
In the first instance, these commands must be run by the
user 'postgres'.
/var/lib/dpkg/info/postgresql.postinst: /etc/init.d/postgresql: Permission denied
Setting up postgresql-contrib (7.1.3-4) ...
[ lam : root ]
donc ca semble bon sauf que :
[ lam : root ] cd /etc/postgresql/
[ lam : postgresql ] la
./ ../ pg_hba.conf pg_ident.conf postgresql.conf postgresql.env postmaster.conf
[ lam : postgresql ] more *
::::::::::::::
pg_hba.conf
::::::::::::::
::::::::::::::
pg_ident.conf
::::::::::::::
::::::::::::::
postgresql.conf
::::::::::::::
::::::::::::::
postgresql.env
::::::::::::::
# postgresql debian package
#
# This section is supplied as part of the Debian package for PostgreSQL.
# It sets the environment for an ordinary user of PostgreSQL and should
# be executed by the .profile or equivalent for the postgres administrator
#
# It is automatically read by all six frontend programs (in the
# postgresql-client package).
[ -r /etc/postgresql/postmaster.conf ] &&
. /etc/postgresql/postmaster.conf
PGDATA=${POSTGRES_DATA:-/var/lib/postgres/data}
PGLIB=/usr/lib/postgresql/lib
PGACCESS_HOME=/usr/lib/postgresql/share/pgaccess
PGHOST=
export PGLIB PGDATA PGACCESS_HOME PGHOST
::::::::::::::
postmaster.conf
::::::::::::::
les fichiers de conf sont vides sauf 1
et de meme lors de l'install apt-get me signale un pb sur
/etc/init.d/postgresql
en fait ce fichier n'est pas en executable, et en plus il est vide !
donc toujours un pb !!!
une petite aide la ou pas ?
--
Nicolas Lamirault
CVF Bordeaux 22 quai de Bacalan
33000 BORDEAUX
Reply to: