pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBug in pg_dump
5+ messages / 4 participants
[nested] [flat]
* Bug in pg_dump
@ 2002-11-11 22:28 Robert John Shepherd <robert@reviewer.co.uk>
2002-11-15 18:51 ` Re: Bug in pg_dump Rod Taylor <rbt@rbt.ca>
2002-11-16 02:37 ` Re: Bug in pg_dump Philip Warner <pjw@rhyme.com.au>
0 siblings, 2 replies; 5+ messages in thread
From: Robert John Shepherd @ 2002-11-11 22:28 UTC (permalink / raw)
To: pgsql-bugs
========================================================================
====
POSTGRESQL BUG REPORT TEMPLATE
========================================================================
====
Your name : Robert John Shepherd
Your email address : robert@reviewer.co.uk
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium IV
Operating System (example: Linux 2.0.26 ELF) : OpenBSD 3.1
PostgreSQL version (example: PostgreSQL-7.2.3): PostgreSQL-7.2.3
Compiler used (example: gcc 2.95.2) : 2.95.3
Please enter a FULL description of your problem:
------------------------------------------------
pg_dump incorrectly dumps db schema when tsearch functions etc are
included
Functions and definitions relating to table creation are specified
correctly
before tables are defined, however those needed for index creation are
specified only after the indexes are created, causing errors during
restore.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
createdb testdb
psql testdb < tsearch.sql
create table t ( a text, b txtidx );
create index a_idx on t using GIST (b);
pg_dump testdb > test.sql
createdb testdb2
psql testdb2 < test.sql
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Dump all functions and types before indexes
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Bug in pg_dump
2002-11-11 22:28 Bug in pg_dump Robert John Shepherd <robert@reviewer.co.uk>
@ 2002-11-15 18:51 ` Rod Taylor <rbt@rbt.ca>
1 sibling, 0 replies; 5+ messages in thread
From: Rod Taylor @ 2002-11-15 18:51 UTC (permalink / raw)
To: Robert John Shepherd <robert@reviewer.co.uk>; +Cc: pgsql-bugs
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
> Dump all functions and types before indexes
This causes errors in other ways. The true solution is to have pg_dump
use a decent dependency tracking mechanism. 7.4 should hold the fix for
pg_dump, although 7.3 has the dependency tracking mechanism.
--
Rod Taylor <rbt@rbt.ca>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Bug in pg_dump
2002-11-11 22:28 Bug in pg_dump Robert John Shepherd <robert@reviewer.co.uk>
@ 2002-11-16 02:37 ` Philip Warner <pjw@rhyme.com.au>
2002-11-16 11:54 ` Re: Bug in pg_dump Robert John Shepherd <robert@reviewer.co.uk>
1 sibling, 1 reply; 5+ messages in thread
From: Philip Warner @ 2002-11-16 02:37 UTC (permalink / raw)
To: Rod Taylor <rbt@rbt.ca>; Robert John Shepherd <robert@reviewer.co.uk>; +Cc: pgsql-bugs
At 01:51 PM 15/11/2002 -0500, Rod Taylor wrote:
>7.4 should hold the fix for
>pg_dump, although 7.3 has the dependency tracking mechanism.
Which means that in theory we can back-patch them for 7.3.1.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Bug in pg_dump
2002-11-11 22:28 Bug in pg_dump Robert John Shepherd <robert@reviewer.co.uk>
2002-11-16 02:37 ` Re: Bug in pg_dump Philip Warner <pjw@rhyme.com.au>
@ 2002-11-16 11:54 ` Robert John Shepherd <robert@reviewer.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Robert John Shepherd @ 2002-11-16 11:54 UTC (permalink / raw)
To: 'Philip Warner' <pjw@rhyme.com.au>; 'Rod Taylor' <rbt@rbt.ca>; +Cc: pgsql-bugs
> >7.4 should hold the fix for
> >pg_dump, although 7.3 has the dependency tracking mechanism.
>
> Which means that in theory we can back-patch them for 7.3.1.
Not wanting to get too involved in discussions as to whether this should
be done or not, I would recommend you nice chaps save your strength for
other more deserving tasks. :)
I have worked around the problem successfully, it's not too difficult
and would only annoy people who change their schema regularly and do
restores from scratch just as regularly.
I'll put these in some docs I'm going to knock up for tsearch in the
next week or so, which should help other newbies like myself who want to
use full text indexing in postgresql.
Yours Unwhettedly,
Robert John Shepherd.
Technical Director
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine http://www.dvd.reviewer.co.uk
For a copy of my Public PGP key, email: pgp@robertsworld.org.uk
^ permalink raw reply [nested|flat] 5+ messages in thread
* Bug in pg_dump
@ 2019-12-10 11:03 Alejandro Meseguer <alex.meseguersilvestre@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Alejandro Meseguer @ 2019-12-10 11:03 UTC (permalink / raw)
To: pgsql-bugs
Hello, I have created a SH file, named "copia.sh", with this code:
*#!/bin/bashRUTASALIDA="copiaSeguridadLuminarias.backup"RENOMBRE="luminarias-$(date
+%F).backup"pg_dump --host=localhost --port=5432 --username=postgres
--no-password --table=srv_industriales.luminarias postgis --format custom
--blobs -v --file=$RUTASALIDA*
When I run this file in a virtual machine whit unix using the command "sh
copia.sh", it is created the file with name
"copiaSeguridadLuminarias.backup?".
Would you tell me why add the interrogation character in the name file?
Thank for your help.
Best regards, Álex Meseguer.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-12-10 11:03 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-11 22:28 Bug in pg_dump Robert John Shepherd <robert@reviewer.co.uk>
2002-11-15 18:51 ` Rod Taylor <rbt@rbt.ca>
2002-11-16 02:37 ` Philip Warner <pjw@rhyme.com.au>
2002-11-16 11:54 ` Robert John Shepherd <robert@reviewer.co.uk>
2019-12-10 11:03 Bug in pg_dump Alejandro Meseguer <alex.meseguersilvestre@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox