luciom2
17-01-2004, 10:05
Ciao ragazzi,tra breve ho l'esame di basi di dati ed ho un grande problema da risolvere:non riesco a configurare postgres su linux red hat 8.0!!!
non capisco perchè ma non riesco a configurarlo:eppure ho eseguito la procedura del mio prof esattamente come dice lui!!
Ma arrivato ad uncerto punto non riesco ad andare avanti!
aiutatemi!!!
grazie
Lucio
Questo è il log:
root@localhost root]# su postgres
bash-2.05b$ initdb –D /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.
Fixing permissions on existing directory /var/lib/pgsql/data... ok
creating directory /var/lib/pgsql/data/base... 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_clog... ok
creating template1 database in /var/lib/pgsql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
creating system views... ok
loading pg_description... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
/usr/bin/postmaster -D /var/lib/pgsql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
bash-2.05b$ pg_ctl start –D /var/lib/pgsql/data
pg_ctl: invalid operation mode: –D
Try 'pg_ctl --help' for more information.
bash-2.05b$ psql lucio
psql: 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"?
bash-2.05b$ psql template1
psql: 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"?
non capisco perchè ma non riesco a configurarlo:eppure ho eseguito la procedura del mio prof esattamente come dice lui!!
Ma arrivato ad uncerto punto non riesco ad andare avanti!
aiutatemi!!!
grazie
Lucio
Questo è il log:
root@localhost root]# su postgres
bash-2.05b$ initdb –D /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.
Fixing permissions on existing directory /var/lib/pgsql/data... ok
creating directory /var/lib/pgsql/data/base... 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_clog... ok
creating template1 database in /var/lib/pgsql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
creating system views... ok
loading pg_description... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
/usr/bin/postmaster -D /var/lib/pgsql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
bash-2.05b$ pg_ctl start –D /var/lib/pgsql/data
pg_ctl: invalid operation mode: –D
Try 'pg_ctl --help' for more information.
bash-2.05b$ psql lucio
psql: 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"?
bash-2.05b$ psql template1
psql: 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"?