pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How can i start up POSTMASTER from unprivilege account
3+ messages / 2 participants
[nested] [flat]

* How can i start up POSTMASTER from unprivilege account
@ 2004-07-30 01:30 Mohammad Tanvir Huda <shayer009@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Mohammad Tanvir Huda @ 2004-07-30 01:30 UTC (permalink / raw)
  To: pgsql-admin


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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How can i start up POSTMASTER from unprivilege account
@ 2004-07-30 14:09 Goulet, Dick <DGoulet@vicr.com>
  2004-08-01 03:54 ` Re: How can i start up POSTMASTER from unprivilege account Mohammad Tanvir Huda <shayer009@yahoo.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Goulet, Dick @ 2004-07-30 14:09 UTC (permalink / raw)
  To: pgsql-admin

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!  <http://us.rd.yahoo.com/mail_us/taglines/virus/*http://promotions.yahoo.com/new_mail/static/protectio...; Mail - Helps protect you from nasty viruses.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How can i start up POSTMASTER from unprivilege account
  2004-07-30 14:09 Re: How can i start up POSTMASTER from unprivilege account Goulet, Dick <DGoulet@vicr.com>
@ 2004-08-01 03:54 ` Mohammad Tanvir Huda <shayer009@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Mohammad Tanvir Huda @ 2004-08-01 03:54 UTC (permalink / raw)
  To: Goulet, Dick <DGoulet@vicr.com>; +Cc: 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

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!

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-08-01 03:54 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-30 01:30 How can i start up POSTMASTER from unprivilege account Mohammad Tanvir Huda <shayer009@yahoo.com>
2004-07-30 14:09 Re: How can i start up POSTMASTER from unprivilege account Goulet, Dick <DGoulet@vicr.com>
2004-08-01 03:54 ` Mohammad Tanvir Huda <shayer009@yahoo.com>

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