Re: [ADMIN] best OS and HW for postgreSQL

hi, yep :~) compiled from source on Suse 9.2 (not SLES 9) best regards Hakan > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ray Stell > Sent: Monday, September 25, 2006 5:03 PM > To: Scott Marlowe > Cc: Jim Nasby; Raul Retamozo; pgsql-admin@

Re: [ADMIN] Move indexes

Hi, in short terms: CREATE TABLESPACE http://www.postgresql.org/docs/8.1/interactive/sql-createtablespace.html CREATE TABLESPACE tablespace_name [ OWNER username ] LOCATION 'directory' ALTER INDEX http://www.postgresql.org/docs/8.1/interactive/sql-alterindex.html ALTER INDEX name SET TABLESPACE

Re: [ADMIN] Installation Postgres 8.1.3 on Linux Suse 9.1

Title: Nachricht Hi,   as far as i know , readline is only needed for the hstory in psql. Ther is no impact on any feature of the server.   Best regards     Hakan KocamanSoftware-Developmentdigame.de GmbHRichard-Byrd-Str. 4-850829 KölnTel.: +49 (0) 221 59 68 88 31Fax: +49 (0) 221 59 68 88 9

Re: [ADMIN] defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters)

kinds of query, because with a non-C Locale you need to define the indices with a different operator- class to use the indices with like-comparisons. See http://www.postgresql.org/docs/8.1/static/indexes-opclass.html for more details. Best regards Hakan Kocaman Software-Development digame.de

Re: [ADMIN] defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters)

jep best regards Hakan Kocaman Software-Development digame.de GmbH Richard-Byrd-Str. 4-8 50829 Köln Tel.: +49 (0) 221 59 68 88 31 Fax: +49 (0) 221 59 68 88 98 Email: [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf