[ADMIN] migration problem 8.1.17 --> 8.4.2

2010-02-09 Thread Lutz Steinborn
Hi, then importing an pg_dump result from a 8.1.17 to a 8.4.2 some varchar fields are not imported and left blank. I've checked the dump file if the fields are correct dumped and they are. So it looks like the import is not working as expected. Any idea what the problem is ? Kindly regards Lutz

Re: [ADMIN] migration problem 8.1.17 --> 8.4.2

2010-02-09 Thread Achilleas Mantzios
Στις Tuesday 09 February 2010 10:48:31 ο/η Lutz Steinborn έγραψε: > Hi, > > then importing an pg_dump result from a 8.1.17 to a 8.4.2 some varchar fields > are not imported and left blank. I've checked the dump file if the fields are > correct dumped and they are. > So it looks like the import is

Re: [ADMIN] migration problem 8.1.17 --> 8.4.2

2010-02-09 Thread Lutz Steinborn
On Tue, 9 Feb 2010 11:35:45 +0200 Achilleas Mantzios wrote: > Στις Tuesday 09 February 2010 10:48:31 ο/η Lutz Steinborn έγραψε: > > Hi, > > > > then importing an pg_dump result from a 8.1.17 to a 8.4.2 some varchar > > fields > > are not imported and left blank. I've checked the dump file if th

Re: [ADMIN] migration problem 8.1.17 --> 8.4.2

2010-02-09 Thread Achilleas Mantzios
Στις Tuesday 09 February 2010 11:54:38 ο/η Lutz Steinborn έγραψε: > On Tue, 9 Feb 2010 11:35:45 +0200 > Achilleas Mantzios wrote: > > > Στις Tuesday 09 February 2010 10:48:31 ΞΏ/Ξ· Lutz Steinborn > > έγραψΡ: > > > Hi, > > > > > > then importing an pg_dump result from a 8.1.17 to a 8.4

Re: [ADMIN] migration problem 8.1.17 --> 8.4.2

2010-02-09 Thread Lutz Steinborn
On Tue, 9 Feb 2010 11:58:46 +0200 Achilleas Mantzios wrote: > Στις Tuesday 09 February 2010 11:54:38 ο/η Lutz Steinborn έγραψε: > > On Tue, 9 Feb 2010 11:35:45 +0200 > > Achilleas Mantzios wrote: > > > > > Στις Tuesday 09 February 2010 10:48:31 ΞΏ/Ξ· Lutz Steinborn > > > έγραψΡ: > >

Re: [ADMIN] Best Replication Tool

2010-02-09 Thread Dimitri Fontaine
Kiswono Prayogo writes: > Hi, i'm really new to postgresql replication, was there any > replication tool for postgresql that can do real-time replication from > 1 database to ~3-10 database (on the other machines) with little > overhead for load balancing purpose? My prefered asynchronous replic

[ADMIN] Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it

2010-02-09 Thread Ray Stell
On Sat, Jan 30, 2010 at 09:59:36AM -0500, Ray Stell wrote: > Running 8.2.15 on RHEL4 the log reports this from autovacuum along with > other pg_ tables: > > VACUUM WARNING: skipping "pg_database" --- only table or database owner can > vacuum it More logging shows the user generating the msg i

[ADMIN] pg_migrator from 32bit to 64bit arch -- does it work? caveats?

2010-02-09 Thread Keith Gabryelski
I'm interested in using pg_migrator to upgrade between postgres server 8.3 and 8.4 on a database about 4G in size. In addition, I'd like to move from a 32bit centos os (currently running the 8.3 server) to 64 bit centos os (running a 64bit arch 8.4 server). Will pg_migrator handle this? Pax, Kei

Re: [ADMIN] pg_migrator from 32bit to 64bit arch -- does it work? caveats?

2010-02-09 Thread Bruce Momjian
Keith Gabryelski wrote: > I'm interested in using pg_migrator to upgrade between postgres server 8.3 > and 8.4 on a database > about 4G in size. > > In addition, I'd like to move from a 32bit centos os (currently running the > 8.3 server) to 64 bit centos os (running a 64bit arch 8.4 server). > >