From: Mohammad Tanvir Huda <shayer009@yahoo.com>
To: Goulet, Dick <DGoulet@vicr.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How can i start up POSTMASTER from unprivilege account
Date: Sat, 31 Jul 2004 20:54:48 -0700 (PDT)
Message-ID: <20040801035448.69034.qmail@web60304.mail.yahoo.com> (raw)
In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA650146C589@25exch1.vicorpower.vicr.com>
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@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 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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: shayer009@yahoo.com, DGoulet@vicr.com
Subject: Re: How can i start up POSTMASTER from unprivilege account
In-Reply-To: <20040801035448.69034.qmail@web60304.mail.yahoo.com>
References: <4001DEAF7DF9BD498B58B45051FBEA650146C589@25exch1.vicorpower.vicr.com> <20040801035448.69034.qmail@web60304.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox