On 3/19/06, Hrishikesh Deshmukh <[EMAIL PROTECTED]> 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) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
