Good day! If you're looking in /etc/rc.d/init.d and trying to modify the "postrgres" script, you're in the right spot. Unfortunately, in Mandrake, you have to do some "magic" to get it to work on anything besides localhost. It astounds me that Mandrake doesn't do this for us (or provide a nice GUI for doing it ourselves), but you actually have to add the -i option to the postgres script yourself. Unfortunately, its not that easy. Mandrake calls pg_ctl to actually start Postgres. It passes /usr/bin/postmaster as an argument. One of the options to pass to pg_ctl are the options to pass to /usr/bin/postmaster (lost yet?). That option is -o. In that option is where you want to pass the -i. Since I've confused myself, here's my line from /etc/rc.d/init.d/Postgres (line 83) su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o '-i' start >/dev/null 2>&1" yips! That will start Postgres with the ability to listen "outside the box" so to speak. You may also have to modify the rules in /var/lib/pg_hba.conf to allow specific connections from certain domains and addresses. I don't know if there's a GUI for this either, I always just do it by hand. As far as a tutorial, there are lots of books and on-line resources for Postgres. I would suggest going to GreatBridge's site. They seem to be doing a good job of promoting the database and have lots of neat stuff available for download. At the moment, pgaccess is it for Linux administration of Postgres. For Windows, there's pgAdmin which is an open source administration console written in (of all things) Visual Basic. It's OK, but not great. I'm planning on starting a new project in the next couple of days to build a very nice administration tool written in Java for Postgres. It will take a while to complete, but if you're interested, please let me know. Hope this helps David -----Original Message----- From: Hector Perez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 9:23 PM To: [EMAIL PROTECTED] Subject: [expert] Postgres with Pgpsql ??? I have 2 cuestions.... By the mandrake Hand..... 1* Which part of initialization script do i have to change 'couse when i try to connect with pgaccess it always tell me the postmaster is not working with -i option. (If I start with the postgres superuser the postmaster -i it works...) By other hand.... 2* some body knows if there are any tutorial to work with Postgres and Plpgsql. 3* some body knows if there are any thing better than the pgaccess for mandrake linux???? Thanks Hector Perez C "Dr PC." _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Want to buy your Pack or Services from MandrakeSoft? Go to http://wwww.mandrakestore.com
