Re: [ADMIN] Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension

Hi Tom, This patch seems to fix the case for me: > > http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=94bdb198813b079467d7ed07c6f72ac896da7161 > > YES. This patch fixes the citext upgrade problem. With the modified share/extension/citext--unpackaged--1.0.sql file just run: CREAT

Re: [ADMIN] rsync and streaming replication

Hi, I did some benchs as suggested by Cedric. At first, I rsynced with options rsync -r --ignore-times --stats -h, and then I rsynced with options rsync -rc --stats -h The total duration of 1st rsync (--ignore-times) for all my tablespaces is 24 min 24 sec. Please find below details printed by

[ADMIN] Postgres database creation using batch files

i want to create a postgres database using batch file, now the normal way of doing this is "C:\Program Files\PostgreSQL\9.0\bin\createdb.exe" -U Myadmin MydatAbseName this create a database with the default database parameters, but i want to create a database with the following parameter WITH

[ADMIN] Question on implementing ident auth correctly.

I am having an issue wrapping my head around ident auth. In particular I always run afoul of the first match wins aspect of the pg_hba.conf. To help clarify I am using postgres 8.4 with the new ident syntax where "sameuser" is now implied. What I would like to do is to use "ident" auth for local

Re: [ADMIN] How and when are encoding DLLs used on Windows?

On Wed, Nov 16, 2011 at 6:57 PM, Tom Lane wrote: > They're used for character set encoding conversions, eg when > database_encoding = UTF8 and client_encoding = LATIN1 (or any other > non-identical combination). Thanks, Tom and Craig; that makes perfect sense. I'd rather not assume anything ab

Re: [ADMIN] Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension

I wrote: > Rudolf van der Leeden writes: >> we are running into a problem with the following upgrade scenario: > Hmm. I think the citext update script is missing a couple of things. This patch seems to fix the case for me: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=94bdb1

Re: [ADMIN] Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension

Rudolf van der Leeden writes: > we are running into a problem with the following upgrade scenario: > Current DB (9.0.5, 300G) is using a table with 2 citext columns and indexes > on both columns. > Using pg_upgrade to move from 9.0.5 to 9.1.1 works OK and is done (without > the ANALYZE) in 30s.