pg_dump -C and locations (with subject this time) - Mailing list pgsql-hackers

From Jim Buttafuoco
Subject pg_dump -C and locations (with subject this time)
Date
Msg-id 200109092136.f89Lasg25138@dual.buttafuoco.net
Whole thread Raw
List pgsql-hackers
(sorry for the repost.  I forgot the subject last time...)

All,

I am working a some patches to the code and I noticed that "pg_dump -C
database" doesn't provide the database location information in the dump
file.  Is this correct?

Thanks
Jim


Example:
datname  | datdba | encoding | datistemplate | datallowconn |
datlastsysoid | datpath | idxpath 
-----------+--------+----------+---------------+--------------+---------------+---------+---------
jb1       |   5433 |        0 | f             | t            |        
18540 |         | PGIDX1
template1 |   5433 |        0 | t             | t            |        
18540 |         | 
template0 |   5433 |        0 | t             | f            |        
18540 |         | 
jb2       |   5433 |        0 | f             | t            |        
18540 | PGDATA1 | PGIDX1
jb3       |   5433 |        0 | f             | t            |        
18540 | PGDATA1 | 
4051      |   5433 |        0 | f             | t            |        
18540 | PGDATA1 | PGIDX1


(Please ignore the IDXPATH column for now as I am trying to add support
for INDEX locations as I am running out of room on my current system and
I don't like the "symlink your own tables/index files" idea)

and the output of pg_dump -C

--
-- Selected TOC Entries:
--
\connect - pgtest
--
-- TOC Entry ID 1 (OID 0)
--
-- Name: jb2 Type: DATABASE Owner: pgtest
--

Create Database "jb2";   <<== This is missing the with location... stuff

\connect jb2 pgtest


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: INHERIT
Next
From: Tatsuo Ishii
Date:
Subject: INV_ARCHIVE?