Re: [ADMIN] Problem restoring a dump

2011-09-14 Thread Johann Spies
On Wed, Sep 14, 2011 at 03:56:27AM +0200, Craig Ringer wrote: You can't change the encoding of a database in-place. Thanks Craig and all the other that responded. Enjoy your day. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data

[ADMIN] database size much bigger than tablespaces on filesystem

2011-09-14 Thread Rob Audenaerde
I have a Postgresql 8.3 instance with tablespaces totalling on about 74G. This is fine. But if I ask Postgresql how big my database is, I get a (unexpected) large answer: 595 GB. This seems very strange. Disk I/O tests on the system are in the 'normal' range, but queries are slower than they

Re: [ADMIN] database size much bigger than tablespaces on filesystem

2011-09-14 Thread Gabriele Bartolini
Hi, On Wed, 14 Sep 2011 04:03:45 -0700, Rob Audenaerde rob.audenae...@valuecare.nl wrote: Is this corruption of the database? Or are there ways to 'fix' this oddity? Try VACUUM ANALYSE and repeat the operation. Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL

Re: [ADMIN] database size much bigger than tablespaces on filesystem

2011-09-14 Thread Guillaume Lelarge
On Wed, 2011-09-14 at 04:03 -0700, Rob Audenaerde wrote: I have a Postgresql 8.3 instance with tablespaces totalling on about 74G. This is fine. But if I ask Postgresql how big my database is, I get a (unexpected) large answer: 595 GB. This seems very strange. Disk I/O tests on the

Re: [ADMIN] database size much bigger than tablespaces on filesystem

2011-09-14 Thread Rob Audenaerde
On Wed, 2011-09-14 at 04:03 -0700, Rob Audenaerde wrote: I have a Postgresql 8.3 instance with tablespaces totalling on about 74G. This is fine. But if I ask Postgresql how big my database is, I get a (unexpected) large answer: 595 GB. This seems very strange. Disk I/O tests on the system

Re: [ADMIN] database size much bigger than tablespaces on filesystem

2011-09-14 Thread Tom Lane
Rob Audenaerde rob.audenae...@valuecare.nl writes: I check te database size like this: select pg_size_pretty(pg_database_size('database')) 595 GB You should also check the space held in $PGDATA/base. I did. It is only 320 MB. Bizarre. Try breaking the results down table-by-table to see if

Re: [ADMIN] pg_upgrade difficulties

2011-09-14 Thread Steve Crawford
On 09/13/2011 05:31 PM, Tom Lane wrote: Steve Crawfordscrawf...@pinpointresearch.com writes: waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping There were problems executing /usr/pgsql-9.1/bin/pg_ctl -w -l

Re: [ADMIN] database size much bigger than tablespaces on filesystem

2011-09-14 Thread Rob Audenaerde
I check te database size like this: select pg_size_pretty(pg_database_size('database')) 595 GB You should also check the space held in $PGDATA/base. I did. It is only 320 MB. Bizarre. Try breaking the results down table-by-table to see if you can find where the discrepancy is.

Re: [ADMIN] pg_upgrade difficulties

2011-09-14 Thread Steve Crawford
On 09/14/2011 08:48 AM, Steve Crawford wrote: On 09/13/2011 05:31 PM, Tom Lane wrote: Steve Crawfordscrawf...@pinpointresearch.com writes: waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping There were problems

Re: [ADMIN] database size much bigger than tablespaces on filesystem

2011-09-14 Thread Tom Lane
Rob Audenaerde rob.audenae...@valuecare.nl writes: It gets stranger. I try this: select tablename , pg_relation_size(tablename) , pg_size_pretty(pg_relation_size(tablename) ) as relsize , pg_size_pretty(pg_total_relation_size(tablename) ) as disksize , pg_total_relation_size(tablename)