dbTalk Databases Forums  

[BUGS] bug on starting postgres

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] bug on starting postgres in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Puvi Subramanian
 
Posts: n/a

Default [BUGS] bug on starting postgres - 09-14-2005 , 07:41 PM






This is a multipart mime message


--Next_1126592656---0-203.199.83.28-8392
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=0AHi,=0A=0A we installed postgres 8.0.3 in fedora core 4 successfully=
.. We created the super user named as postgres to start postgres. When i exe=
cute the command "/usr/local/pgsql/bin/postmaster -i -D data" in my termin=
al it gives bur that=0Apostmaster cannot access the server configuration fi=
le "/home/postgres/data/postgresql.conf": No such file or directory=0A=0Apl=
z help us to proceed further=0A=0Awith regards=0APuvi.S=0A
--Next_1126592656---0-203.199.83.28-8392
Content-type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<P>=0A&nbsp; <BR>=0AHi,<BR>=0A<BR>=0A&nbsp; &nbsp; we installed postgres 8.=
0.3 in fedora core 4 successfully. We created the super user named as postg=
res to start postgres. When i execute the command&nbsp; &quot;/usr/local/pg=
sql/bin/postmaster -i -D data&quot; in my terminal it gives bur that<BR>=0A=
postmaster cannot access the server configuration file &quot;/home/postgres=
/data/postgresql.conf&quot;: No such file or directory<BR>=0A<BR>=0Aplz hel=
p us to proceed further<BR>=0A<BR>=0Awith regards<BR>=0APuvi.S<BR>=0A=0A</P=
Quote:
=0A<br><br>=0A<a href=3D"http://adworks.rediff.com/cgi-bin/AdWorks/sigclic=
k.cgi/www.rediff.com/signature-home.htm/1507191490@Middle5?PARTNER=3D3"><IM=
G SRC=3D"http://adworks.rediff.com/cgi-bin/AdWorks/sigimpress.cgi/www.redif=
f.com/signature-home.htm/1963059423@Middle5?OAS_query=3Dnull&PARTNER=3D3" B=
ORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1126592656---0-203.199.83.28-8392--



Reply With Quote
  #2  
Old   
John R Pierce
 
Posts: n/a

Default Re: [BUGS] bug on starting postgres - 09-14-2005 , 10:36 PM






Puvi Subramanian wrote:

Quote:
Hi,

we installed postgres 8.0.3 in fedora core 4 successfully. We
created the super user named as postgres to start postgres. When i
execute the command "/usr/local/pgsql/bin/postmaster -i -D data" in
my terminal it gives bur that
postmaster cannot access the server configuration file
"/home/postgres/data/postgresql.conf": No such file or directory

plz help us to proceed further

if your pgsql directory is /usr/local/pgsql, chances are, the default
data directory is in /usr/local/pgsql/data ...

But, since you're running Fedora, and that uses SysVinit routines, look
in /usr/local/pgsql/postgresql-(version)/contrib/start-scripts and you
should find a script `linux` there.... as root, copy this to
/etc/init.d/postgresql and chmod that +x then still as root, do
`chkconfig postgresql --add`

now, you can start/stop postgres as root with `service postgresql start`
and `service postgresql stop`.. further, if you now do `chkconfig
postgresql on` it will autostart each time you reboot, running as a
system service.

if you really just want to run it manually, I'd consider changing the
postgres user account's home directory to /usr/local/pgsql rather than
/home/postgres... `usermod -d /usr/local/pgsql postgres`

regardless, you usually need to edit the postgresql.conf and pg_hba.conf
files to support the desired access types


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.