Unix Technical Forum

Re: PG on zeta 1.0

This is a discussion on Re: PG on zeta 1.0 within the pgsql Novice forums, part of the PostgreSQL category; --> > > $ ./pg_ctl -D /boot/home/database -l logfile start > > postmaster starting > > > the output is ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 10:53 PM
sam karush
 
Posts: n/a
Default Re: PG on zeta 1.0

> > $ ./pg_ctl -D /boot/home/database -l logfile start
> > postmaster starting
> >

> the output is going to the logfile. Can you take off the "-l logfile"
> part and send the list the error message for that portion.
> > Attempts to login with phpPgAdmin fail.

> so, it is running, but you just can't connect?
> >



Well, I have managed to get PG running. I had to copy the file boot/zeta/etc/hosts-sample, save as 'hosts', and add the line:

127.0.0.1 localhost

Now PG starts reliably. I still can't connect with phpPgAdmin, but a quick trip through the archives of that group shows that to be a very common problem, with no concrete solution.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 10:53 PM
Mark Campbell
 
Posts: n/a
Default Re: PG on zeta 1.0

Hi

Would you not have to start the postmaster with the "-i" switch to allow
TCP/IP connections to the DB?

Regards

Mark Campbell


Confidentiality Notice: http://ucs.co.za/conf.html



sam karush wrote:
> > > $ ./pg_ctl -D /boot/home/database -l logfile start
> > > postmaster starting
> > >

> > the output is going to the logfile. Can you take off the "-l logfile"
> > part and send the list the error message for that portion.
> > > Attempts to login with phpPgAdmin fail.

> > so, it is running, but you just can't connect?
> > >

>
>
> Well, I have managed to get PG running. I had to copy the file
> boot/zeta/etc/hosts-sample, save as 'hosts', and add the line:
>
> 127.0.0.1 localhost
>
> Now PG starts reliably. I still can't connect with phpPgAdmin, but a
> quick trip through the archives of that group shows that to be a very
> common problem, with no concrete solution.
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:13 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com