i have instaled postgesql 7.1.11 on red hat el 5.3
after installtion its worked.
when i change the line in /etc/rc.d/init.d postgresql as export PGDATA=/var/lib/pgsql/nampetdb (export PGDATA=/var/lib/pgsql/data)
after that i could not restart the postgresql
the contents of postgresql log id
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 UTF8.
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/pg_twophase ... ok
creating directory /var/lib/pgsql/data/pg_multixact/members ... ok
creating directory /var/lib/pgsql/data/pg_multixact/offsets ... 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_authid ... ok
enabling unlimited row size for system tables ... ok
initializing dependencies ... 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
copying template1 to postgres ... 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
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 UTF8.
fixing permissions on existing directory /var/lib/pgsql/nampetdb ... initdb: could not change permissions of directory "/var/lib/pgsql/nampetdb": Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": No such file or directory
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
LOG: logger shutting down
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
pls give me sugestion to handle thid..
with thanks
Sha
after installtion its worked.
when i change the line in /etc/rc.d/init.d postgresql as export PGDATA=/var/lib/pgsql/nampetdb (export PGDATA=/var/lib/pgsql/data)
after that i could not restart the postgresql
the contents of postgresql log id
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 UTF8.
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/pg_twophase ... ok
creating directory /var/lib/pgsql/data/pg_multixact/members ... ok
creating directory /var/lib/pgsql/data/pg_multixact/offsets ... 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_authid ... ok
enabling unlimited row size for system tables ... ok
initializing dependencies ... 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
copying template1 to postgres ... 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
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 UTF8.
fixing permissions on existing directory /var/lib/pgsql/nampetdb ... initdb: could not change permissions of directory "/var/lib/pgsql/nampetdb": Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": No such file or directory
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
LOG: logger shutting down
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/nampetdb/postgresql.conf ": Permission denied
pls give me sugestion to handle thid..
with thanks
Sha
Comment