Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Rien Kok on June 09, 2003, 06:18:29 PM

Title: Installing PostgreSQL
Post by: Rien Kok on June 09, 2003, 06:18:29 PM

Hi,

I've downloaded PostgreSQL from: http://www.star-support.com/downloads/mitel/contrib/postgresql

After installing, I created users as su Postgres and allowed them to create databases etc.

When I log on as "root" I am able to create databases, inquire databases, define triggers and so on (with psql).  This works fine.

Questions:
1)
Now I must start PostgreSQL manually by typing the command: "service postgresql start". How can I make PostgreSQL to start automatically every time I reboot the server.

2)
I can't approach the database from a Windows client. (ODBC, PgAdminII). I remember that I've read somewhere that I than have to start "Postmaster" with the "i" option but I'm not sure, nor do I know how to do that.

The installation uses automatically the directories: var/lib/pqsql/data and usr/lib/pgsql


Thanks,

Rien Kok

Title: Re: Installing PostgreSQL
Post by: guestHH on June 09, 2003, 08:32:29 PM

1. add a symbolic link in /etc/rc.d/rc7.d/99postgresql  pointing to /etc/rc.d/init.d/postgresql

2. sorry can't help you

regards,
guestHH

Title: Re: Installing PostgreSQL
Post by: Barry Fitzmaurice on June 10, 2003, 01:02:55 PM

1. As above

2. http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-redhat

explains how to get postgreSQL listening to ODBC calls.  

Barry

Title: Re: Installing PostgreSQL
Post by: Gordon on July 09, 2003, 05:25:59 AM

2. add this line to your pg_hba.conf  file.  It allows access from within your own network to the postgresql server

host all        192.168.0.0     255.255.255.0   password

Stop and restart the postgres service  with the -i switch and you will then be able to connect using odbc, and native calls such as pgaccess, pgadmin, psql (cygwin).


read the pg_hba.conf file - it has extensive documentation within it