Re: [HACKERS] pg_dumpall prob - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] pg_dumpall prob
Date
Msg-id 200001062117.QAA21472@candle.pha.pa.us
Whole thread Raw
In response to pg_dumpall prob  ("Patrick Welche,SCC,ext.35710," <prlw1@newn.cam.ac.uk>)
List pgsql-hackers
> line 50 of pg_dumpall (cvs of today) has
> 
> psql -l -A -q -t| tr '|' ' ' | grep -v '^template1 ' | \
> 
> psql -l -A -q -t| tr '|' ' '
> 
> will return a list of databases beginning with the two lines

OK, this is an artifact of the new psql format.  I have changed to the
code to be:
psql -l -A -q -t | grep '|' | tr '|' ' ' | sed -n '2,$p' | \grep -v '^template1 ' | \

This removes all lines with no pipe, changes pipe to space, and removes
the first line and the template1 line from the output. This should work.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [HACKERS] Thomas! FOREIGN KEY problem!
Next
From: "Ansley, Michael"
Date:
Subject: RE: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL