Re: OpenSuse10.0 and postgresql

On 3/19/06, Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> wrote:
> Can somebody please tell me where i can find rpms for postgesql on OpenSuse
> 10.0?

opensuse10 comes with PostgreSQL 8.0.1, installable once you configure
the installation sources correctly. (See
http://en.opensuse.org/Mirrors_Released_Version)

Unsupported PostgreSQL 8.1.x packages are available from:
http://ftp.suse.com/pub/projects/postgresql/

Not sure about the unsupported 8.1.x packages, but the default ones
are integrated with suse's startup scripts, so:

* Go to /var/lib/pgsql/ and edit pg_hba.conf and postgresql.conf You
might have to do a "rcpostgresql start; rcpostgresql stop" to force it
to create the default database cluster (aka "initdb" in PostgreSQL
docs), before you can edit those two files. If you do so, you don't
need to manually initdb.

* "rcpostgresql start" to start postgresql server manually. This is
equivalent to "pg_ctl -D /var/lib/pgsql -l /var/log/postgresql start"

* "chkconfig -a postgresql" to add postgresql to the services to
start up during boot.

(This is a re-send, forgot to Cc the first time round)