Re: How can i start up POSTMASTER from unprivilege account

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

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 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
Success. The database server should be started automatically.
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

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

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"?

Can you please guide me where is the problem?

That will be very helpful

Regards

Mohammad Tanvir Huda

"Goulet, Dick" <DGoulet(at)vicr(dot)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(at)yahoo(dot)com]
Sent: Thursday, July 29, 2004 9:30 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] How can i start up POSTMASTER from unprivilege account

Hello 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!