[ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Lukasz Brodziak
Hello, I have a question regarding pg_attribute. In which file it is stored because the relfilenode for it shows 0 and file 1249 isn't present in the folder. -- Łukasz Brodziak -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.po

Re: [ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Steve Crawford
On 03/07/2012 05:14 AM, Lukasz Brodziak wrote: Hello, I have a question regarding pg_attribute. In which file it is stored because the relfilenode for it shows 0 and file 1249 isn't present in the folder. select pg_relation_filepath('pg_attribute'); From the docs, relfilenode is: "Name of the

Re: [ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Tom Lane
Steve Crawford writes: > On 03/07/2012 05:14 AM, Lukasz Brodziak wrote: >> I have a question regarding pg_attribute. In which file it is stored >> because the relfilenode for it shows 0 and file 1249 isn't present in >> the folder. > select pg_relation_filepath('pg_attribute'); > From the docs,

[ADMIN] table names seem identical

2012-03-07 Thread Ray Stell
how I can differentiate these: oamp=# \z public.c3* Access privileges Schema | Name | Type | Access privileges | Column access privileges +---+---+---+-- public | c3p0_c

Re: [ADMIN] speedup pg_dumpall

2012-03-07 Thread Michael Monnerie
Am Donnerstag, 23. Februar 2012, 11:08:29 schrieb Kevin Grittner: > > What can I do to improve pg_dump performance? > > > I can't help wondering why you're running it. For routine backups > it is generally not your best option in PostgreSQL. PITR or warm > standby are generally more useful for ro

Re: [ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Lukasz Brodziak
Thanks a lot I have found file I needed let's hope I will be able to fix the problem now as I cannot connect to the database because I get 'catalog is missing 1 attribute for relation 2662' which I hope to be able to repair by getting the pg_attribute file from another db. 2012/3/7 Tom Lane : > St

Re: [ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Steve Crawford
On 03/07/2012 09:03 AM, Lukasz Brodziak wrote: Thanks a lot I have found file I needed let's hope I will be able to fix the problem now as I cannot connect to the database because I get 'catalog is missing 1 attribute for relation 2662' which I hope to be able to repair by getting the pg_attribut

Re: [ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Tom Lane
Steve Crawford writes: > On 03/07/2012 09:03 AM, Lukasz Brodziak wrote: >> Thanks a lot I have found file I needed let's hope I will be able to >> fix the problem now as I cannot connect to the database because I get >> 'catalog is missing 1 attribute for relation 2662' which I hope to be >> able

Re: [ADMIN] table names seem identical

2012-03-07 Thread Walter Hurry
On Wed, 07 Mar 2012 10:39:48 -0500, Ray Stell wrote: > how I can differentiate these: > > oamp=# \z public.c3* >Access privileges > Schema | Name | Type | Access privileges | Column > access privileges > +---+

Re: [ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Lukasz Brodziak
Ok, so the case is that I don't have the exact cause of the problem as it occured on one of our clients dbs. The PG version is 9.0.0 and the OS is windows XP. The DB is able to start (I have the data folder) but when I connect to the db from our application (or pgAdmin) I come across the above ment

Re: [ADMIN] pg_attribute file in PostgreSQL 9.0

2012-03-07 Thread Kevin Grittner
Tom Lane wrote: > Steve Crawford writes: >> On 03/07/2012 09:03 AM, Lukasz Brodziak wrote: >>> Thanks a lot I have found file I needed let's hope I will be >>> able to fix the problem now as I cannot connect to the database >>> because I get 'catalog is missing 1 attribute for relation 2662' >>>

Re: [ADMIN] table names seem identical

2012-03-07 Thread Ray Stell
On Wed, Mar 07, 2012 at 05:41:41PM +, Walter Hurry wrote: > On Wed, 07 Mar 2012 10:39:48 -0500, Ray Stell wrote: > > misc=# create table test1(flag varchar(1)); > CREATE TABLE > misc=# create table "test1 "(flag varchar(1)); > CREATE TABLE yeah, that is the case, the \z output is truncated

Re: [ADMIN] logging issue

2012-03-07 Thread Campbell, Lance
Thanks so much for the response. Logging works great. Many thanks to the PostgreSQL development team for building such a wonderful database. 9.1 is working great. Thanks, Lance Campbell Software Architect Web Services at Public Affairs 217-333-0382 -Original Message- From: Jerry S

[ADMIN] Postgres server crashing unexpectedly.

2012-03-07 Thread umashankar narayanan
Version : 8.3 Below is the log from the server. ---

Re: [ADMIN] table names seem identical

2012-03-07 Thread David Kerr
On 03/07/2012 07:39 AM, Ray Stell wrote: how I can differentiate these: oamp=# \z public.c3* Access privileges Schema | Name | Type | Access privileges | Column access privileges +---+---+---