| From: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> |
|---|---|
| To: | Sebastien Boisvert <sebastienboisvert(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Significance of numbers in server errors? |
| Date: | 2011-03-05 00:13:18 |
| Message-ID: | AANLkTinJvmjFQMEZteBLYn522VD0_xUYkJexp1yCb2xt@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4 March 2011 23:15, Sebastien Boisvert <sebastienboisvert(at)yahoo(dot)com> wrote:
> I know the second is the database's directory, the last is the pg_attribute
> table (in this example), but I haven't figured out what the first is.
I think that the first is probably the tablespace:
postgres=# select oid,* from pg_tablespace;
-[ RECORD 1 ]-----------
oid | 1663
spcname | pg_default
spcowner | 10
spclocation |
spcacl |
spcoptions |
-[ RECORD 2 ]-----------
oid | 1664
spcname | pg_global
spcowner | 10
spclocation |
spcacl |
spcoptions |
--
Regards,
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2011-03-05 00:45:25 | Re: database is bigger after dump/restore - why? (60 GB to 109 GB) |
| Previous Message | Sebastien Boisvert | 2011-03-04 23:15:23 | Significance of numbers in server errors? |