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:
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
Steve Crawford scrawf...@pinpointresearch.com 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
how I can differentiate these:
oamp=# \z public.c3*
Access privileges
Schema | Name | Type | Access privileges | Column access
privileges
+---+---+---+--
public |
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 routine
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
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
Steve Crawford scrawf...@pinpointresearch.com 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'
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
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
Tom Lane t...@sss.pgh.pa.us wrote:
Steve Crawford scrawf...@pinpointresearch.com 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
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 it
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
Version : 8.3
Below is the log from the server.
---
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
15 matches
Mail list logo