установка postgre

[Elenka]

при ./configure

daet error:

...
checking syslog.h usability... yes
checking syslog.h presence... yes
checking for syslog.h... yes
checking for optreset... no
checking for strtoll... yes
checking for strtoull... yes
checking for atexit... yes
checking for _LARGEFILE_SOURCE value needed for large files... no
checking for fseeko... (cached) yes
checking test program... failed
configure: error:
*** Could not execute a simple test program.  This may be a problem
*** related to locating shared libraries.  Check the file \'config.log\'
*** for the exact reason.

скачано отсюда: http://ftp://ftp13.us.postgresql.org/mirror/postgresql/v8.0.2/postgresql-8.0.2.tar.gz

[commander]

Elenka
какая ось?

[Elenka]

red hat linux 9

[commander]

Elenka
gcc установленно?
а вообще ставь из rpm ... и будет тебе счастье...

[Elenka]

из рпм:

# rpm -ihv postgresql-8.0.1-2PGDG.i686.rpm
# rpm -ihv postgresql-server-8.0.1-2PGDG.i686.rpm
# rpm -ihv postgresql-devel-8.0.1-2PGDG.i686.rpm
# rpm -ihv postgresql-contrib-8.0.1-2PGDG.i686.rpm

далее:

# su - postgres
$ cd data
$ chmod u+w pg_hba.conf
>`pg_hba.conf\': No such file or directory

-bash-2.05b$ /usr/bin/postgres start
/usr/bin/postgres cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": No such file or directory

[Elenka]

что я делаю не так ?

спасибо!

[commander]

Elenka
postgresql.conf в указанной директории есть?
initdb делала?

[Elenka]

data dir voobshe pustaya

[commander]

initdb сделай...

[Elenka]

по этому мануалу  делаю: http://www.grape-info.com/doc/linux/config/postgresql-7.0.2.html

файл postgres вот тут: /usr/bin/postgres
/etc/init.d/postgres - этот не существует

при попытке создать юзера:

-bash-2.05b$ createuser dbuser
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
createuser: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

[Elenka]

-bash-2.05b$ initdb --pgdata=/var/lib/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UNICODE.

fixing permissions on existing directory /var/lib/pgsql/data ... ok
creating directory /var/lib/pgsql/data/global ... ok
creating directory /var/lib/pgsql/data/pg_xlog ... ok
creating directory /var/lib/pgsql/data/pg_xlog/archive_status ... ok
creating directory /var/lib/pgsql/data/pg_clog ... ok
creating directory /var/lib/pgsql/data/pg_subtrans ... ok
creating directory /var/lib/pgsql/data/base ... ok
creating directory /var/lib/pgsql/data/base/1 ... ok
creating directory /var/lib/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/1 ... ok
initializing pg_shadow ... ok
enabling unlimited row size for system tables ... ok
initializing pg_depend ... ok
creating system views ... ok
loading pg_description ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    postmaster -D /var/lib/pgsql/data
or
    pg_ctl -D /var/lib/pgsql/data -l logfile start

[commander]

Elenka
иногда вообще полезно почитать и перевести, что тебе система отвечает...
man initdb !!!!

[Elenka]

после следующих действий, снова не видит ДБ:

bash-2.05b$ createuser dbuser
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
createuser: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

[commander]

Elenka
translate.ru!!!
Success. You can now start the database server using:
postmaster -D /var/lib/pgsql/data
or
pg_ctl -D /var/lib/pgsql/data -l logfile start

[commander]

Elenka
так запусти сервер!
Success. You can now start the database server using:
postmaster -D /var/lib/pgsql/data
or
pg_ctl -D /var/lib/pgsql/data -l logfile start