[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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: