Re: [ADMIN] Why would queries fail with 'could not stat file' after CLUSTER?

2012-04-09 Thread raghu ram
On Tue, Apr 10, 2012 at 10:00 AM, Sashbeer Bhandari wrote: > Hi > Good Morning, > > I am using Postgresql DB 8.2 and my encoding is in SQL_ASCII ,. I want to > convert it in UTF8, Please help me it. > > Convert a database in the SQL_ASCII format into one of the UTF-8 format:: template1=# create d

Re: [ADMIN] Giant Postgresql Database Cluster Folder

2012-04-09 Thread raghu ram
On Tue, Apr 10, 2012 at 11:21 AM, Kiruba suthan wrote: > > > > We are using Postgresql Database server to host DB for an analytical tool > I am working on. Basically this DB has metrics about files. Row count of > few tables are more than 18 million. But the content of the tables are > basic data

[ADMIN] Giant Postgresql Database Cluster Folder

2012-04-09 Thread Kiruba suthan
We are using Postgresql Database server to host DB for an analytical tool I am working on. Basically this DB has metrics about files. Row count of few tables are more than 18 million. But the content of the tables are basic data types like numbers, date & string. No binary data is stored. The size

Re: [ADMIN] Why would queries fail with 'could not stat file' after CLUSTER?

2012-04-09 Thread Sashbeer Bhandari
Hi Good Morning, I am using Postgresql DB 8.2 and my encoding is in SQL_ASCII ,. I want to convert it in UTF8, Please help me it. Thanks Sashbeer On Mon, Apr 9, 2012 at 9:42 PM, David Schnur wrote: > The software I develop bundles a Postgres 8.3.15 database for storage. > Several users are

Re: [ADMIN] Why would queries fail with 'could not stat file' after CLUSTER?

2012-04-09 Thread Raghavendra
On Mon, Apr 9, 2012 at 9:42 PM, David Schnur wrote: > The software I develop bundles a Postgres 8.3.15 database for storage. > Several users are reporting errors like this: > > ProgrammingError: could not stat file "base/16384/52212305.1": Permission > denied > > I'm unable to reproduce this mys

[ADMIN] Why would queries fail with 'could not stat file' after CLUSTER?

2012-04-09 Thread David Schnur
The software I develop bundles a Postgres 8.3.15 database for storage. Several users are reporting errors like this: ProgrammingError: could not stat file "base/16384/52212305.1": Permission denied I'm unable to reproduce this myself, but it's clearly a real issue. The response to all previous