Thread: 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