When using "pg_dumpall" and a subsequent "psql -e" to rebuild the data base
the process failed. The failure was due to the "pg_dumpall" (and "pg_dump") handling
of CONSTRAINTS. Details are provided below.
Is this a known bug? Is there a patch for it?
tnx,
mike
--
I can't get past the below error in the installation of v6.4. What to I
do next?
tnx
mike
-
$ initdb
initdb: using /usr/local/pgsql/lib/local1_template1.bki.source as input to
create the template database.
initdb: using /usr/local/pg
>
> I was looking for a DBMS that supports multidimensional index structures
> like rectangles and points. During my search I found the link to the
> PostgreSQL system.
I have used the 'box' and 'line' objects in the past (ver 6.3 or so).
The use was short lived...to determine if specific satell
Note the
use
of the ':' for delimiting legends. Extra legend will be ignored. If
there are
not enough legends, the ones specified will be used. The remaining
legends are
then F defaults.
=item B<-f out_file_base_name> creates output files
F and
F. By default, F are used.
=item B<-q> is quiet mode. If specified, then the postscript files are
generated
but no screen output is shown. If not specified, then a screen output is
displayed
for 5 seconds, then the postscript file written.
=back
=head1 NOTES
$Source: /home/mak/CVS/misc_util/pp,v $
$Author: mak $
$Date: 1998/08/12 19:01:55 $
$Revision: 1.5 $
Dr Michael A. Koerber
MIT/LL
Radar Imaging Techniques
I have had trouble on numerous occasions "undumping" a pg_dump. Below is
a perl script that I use as a pipe for undumping...hope it helps
.pg_undump.
#!/usr/bin/perl -p
# This script is a pipe that is used to break up PSQL dumps into pieces
# that are more manageable by the postmaster.