Обсуждение: Start with -i

  I just upgraded to redhat 9 and cannot connect to my database through
odbc.  I am trying to start the postmaster with the -i option.  How do you
do this from a restart in redhat 9?



Thank You,
Christopher A. Goodfellow
Director of Information Technology
Tealuxe, Inc.
Phone: 508 520 7887 ex:22
Fax: 508 528 8999
www.tealuxe.com
tea for all

Christopher A. Goodfellow wrote:

>  I just upgraded to redhat 9 and cannot connect to my database through
>odbc.  I am trying to start the postmaster with the -i option.  How do you
>do this from a restart in redhat 9?
>
By a restart, do you mean a database or a server restart?

>
>
>
>Thank You,
>Christopher A. Goodfellow
>Director of Information Technology
>Tealuxe, Inc.
>Phone: 508 520 7887 ex:22
>Fax: 508 528 8999
>www.tealuxe.com
>tea for all
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>
>

Read the docs at
http://www.postgresql.org/docs/7.4/static/postmaster-start.html for
instructions on how to start the postmaster with the -i command (note
that your data directory will probably be different). You haven't given
us information on which user you're using to start it, or whether or not
you have modified your postgersql.conf file, but the docs should help
you out. There is also information on how to configure the server so
postgres starts each time the server starts.

Ron

"Christopher A. Goodfellow" <cgoodfellow@tealuxe.com> writes:
>   I just upgraded to redhat 9 and cannot connect to my database through
> odbc.  I am trying to start the postmaster with the -i option.  How do you
> do this from a restart in redhat 9?

Rather than messing with command line switches, just set the flag in
postgresql.conf --- it's "tcpip_socket" there.  The init script for
Postgres isn't very helpful about letting you pass command line switches
to the postmaster, but there's really no need to, since you can do
anything you want via postgresql.conf.

            regards, tom lane