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; --> >Would you not have to start the postmaster with the "-i" switch to allow TCP/IP connections to the DB? ...


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

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

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

Being a novice, first timer, i'm not sure what the "-i" switch is, or what the command looks like. Please post. Thanks!

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

On my Sco-Openserver Unix machine, I need to start the postmaster like this

nohup pg_ctl -o -i start &

Also keep in mind that I have my environment variables setup eg.

PGDATA=/usr/local/pgsql/data
PGDATABASE=thenameofthedb
PGHOST=thenameofthemachine
PGUSER=postgres

Hope that helps


Mark Campbell


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



sam karush wrote:
> >Would you not have to start the postmaster with the "-i" switch to

> allow TCP/IP connections to the DB?
> Being a novice, first timer, i'm not sure what the "-i" switch is, or
> what the command looks like. Please post. Thanks!
>


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 06:38 AM.


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