Re: How can i start up POSTMASTER from unprivilege account - Mailing list pgsql-admin
| From | Mohammad Tanvir Huda |
|---|---|
| Subject | Re: How can i start up POSTMASTER from unprivilege account |
| Date | |
| Msg-id | 20040801035448.69034.qmail@web60304.mail.yahoo.com Whole thread Raw |
| In response to | Re: How can i start up POSTMASTER from unprivilege account ("Goulet, Dick" <DGoulet@vicr.com>) |
| List | pgsql-admin |
Hello
Actually i am not sure at which user group they assignment me. I have try the following things . But havent have much lluck. Postgres is installed in serveral places in the server.
mahar:~> locate postmaster
/etc/postgresql/postmaster.conf
/opt/nimrod/pgsql-7.3.6/bin/postmaster
/opt/nimrod/pgsql-7.3.6/doc/html/app-postmaster.html
/opt/nimrod/pgsql-7.3.6/doc/html/postmaster-shutdown.html
/opt/nimrod/pgsql-7.3.6/doc/html/postmaster-start.html
/opt/nimrod/pgsql-7.3.6/man/man1/postmaster.1
/usr/lib/postgresql/bin/postmaster
/usr/share/man/man1/postmaster.1.gz
/etc/postgresql/postmaster.conf
/opt/nimrod/pgsql-7.3.6/bin/postmaster
/opt/nimrod/pgsql-7.3.6/doc/html/app-postmaster.html
/opt/nimrod/pgsql-7.3.6/doc/html/postmaster-shutdown.html
/opt/nimrod/pgsql-7.3.6/doc/html/postmaster-start.html
/opt/nimrod/pgsql-7.3.6/man/man1/postmaster.1
/usr/lib/postgresql/bin/postmaster
/usr/share/man/man1/postmaster.1.gz
I create data folder in my own space and given the write to my user name
mahar:~> /usr/lib/postgresql/bin/initdb -D data
The files belonging to this database system will be owned by user "huda".
This user must also own the server process.
The files belonging to this database system will be owned by user "huda".
This user must also own the server process.
The database cluster will be initialized with locale C.
fixing permissions on existing directory data... ok
creating directory data/base... ok
creating directory data/global... ok
creating directory data/pg_xlog... ok
creating directory data/pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in 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
creating directory data/base... ok
creating directory data/global... ok
creating directory data/pg_xlog... ok
creating directory data/pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in 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
Success. The database server should be started automatically.
If not, you can start the database server using:
If not, you can start the database server using:
/etc/init.d/postgresql start
Then i edit the file postgresql.conf and uncomment the following lines so that it cant talk to a TCP/IP port
tcpip_socket = false
max_connections = 100
# note: increasing max_connections costs about 500 bytes of shared
# memory per connection slot, in addition to costs from shared_buffers
# and max_locks_per_transaction.
#superuser_reserved_connections = 2
port = 5432
max_connections = 100
# note: increasing max_connections costs about 500 bytes of shared
# memory per connection slot, in addition to costs from shared_buffers
# and max_locks_per_transaction.
#superuser_reserved_connections = 2
port = 5432
Then i try to start up the server and it showed me that it started successfully,
su -c '/usr/lib/postgresql/bin/pg_ctl start -D data -l serverlog' huda
Password:
postmaster successfully started
Password:
postmaster successfully started
But when i am trying to create the database or log in to psql shell it giving me error .
mahar:~> /usr/lib/postgresql/bin/psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
mahar:~> /usr/lib/postgresql/bin/create
createdb* createlang* createuser*
mahar:~> /usr/lib/postgresql/bin/createdb test
createdb: 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 "/var/run/postgresql/.s.PGSQL.5432"?
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
mahar:~> /usr/lib/postgresql/bin/create
createdb* createlang* createuser*
mahar:~> /usr/lib/postgresql/bin/createdb test
createdb: 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 "/var/run/postgresql/.s.PGSQL.5432"?
Can you please guide me where is the problem?
That will be very helpful
Regards
Mohammad Tanvir Huda
"Goulet, Dick" <DGoulet@vicr.com> wrote:
Your username would have to have the same group as PostGreSQL assigned to you, normally DBA.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Mohammad Tanvir Huda [mailto:shayer009@yahoo.com]
Sent: Thursday, July 29, 2004 9:30 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] How can i start up POSTMASTER from unprivilege accountHello All
I have an account in our cluster. This is a normal linux use.
Our administrator have set up postgres there. But he have n't start up the postgreSQL server in the cluster.
Can anyone tell me how can I start up the postmaster and from an user space. Where should i need to configure. As getting administrative privilege cannot be possible as it is in an university.
Pls tell me at your earliest. I am very new to postgreSQL.
Pls help me out.
Regards
Shayer
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
pgsql-admin by date: