pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddump with lo
4+ messages / 3 participants
[nested] [flat]
* dump with lo
@ 2006-03-02 11:41 Maciej Piekielniak <piechcio@isb.com.pl>
2006-03-02 15:21 ` Re: dump with lo Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Maciej Piekielniak @ 2006-03-02 11:41 UTC (permalink / raw)
To: pgsql-sql
Hello pgsql-sql,
I try copy my old database with large objects from postgresql7.4 to
postgresql-8.1.
How can I dump database with lo? pg_dumpall don't save lo.
--
Best regards,
Maciej mailto:piechcio@isb.com.pl
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dump with lo
2006-03-02 11:41 dump with lo Maciej Piekielniak <piechcio@isb.com.pl>
@ 2006-03-02 15:21 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-03-02 16:59 ` Re: dump with lo Maciej Piekielniak <piechcio@isb.com.pl>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2006-03-02 15:21 UTC (permalink / raw)
To: Maciej Piekielniak <piechcio@isb.com.pl>; +Cc: pgsql-sql
Maciej Piekielniak <piechcio@isb.com.pl> writes:
> I try copy my old database with large objects from postgresql7.4 to
> postgresql-8.1.
> How can I dump database with lo? pg_dumpall don't save lo.
Use 8.1's pg_dump and pg_dumpall to dump from the old server. We fixed
that problem finally.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dump with lo
2006-03-02 11:41 dump with lo Maciej Piekielniak <piechcio@isb.com.pl>
2006-03-02 15:21 ` Re: dump with lo Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-03-02 16:59 ` Maciej Piekielniak <piechcio@isb.com.pl>
2006-03-17 15:50 ` Re: dump with lo Markus Schaber <schabi@logix-tt.com>
0 siblings, 1 reply; 4+ messages in thread
From: Maciej Piekielniak @ 2006-03-02 16:59 UTC (permalink / raw)
To: pgsql-sql
Hello Tom,
Thursday, March 2, 2006, 4:21:22 PM, you wrote:
TL> Maciej Piekielniak <piechcio@isb.com.pl> writes:
>> I try copy my old database with large objects from postgresql7.4 to
>> postgresql-8.1.
>> How can I dump database with lo? pg_dumpall don't save lo.
TL> Use 8.1's pg_dump and pg_dumpall to dump from the old server. We fixed
TL> that problem finally.
TL> regards, tom lane
I try to copy pg_wrapper,PgCommon.pm to /usr/bin but when i type
pg_dump -V i got:
Argument "." isn't numeric in numeric lt(<) at PgCommon.pm line 439
Error: You must install at least one
postgresql-client-<version>package
I have debian sarge
--
Best regards,
Maciej mailto:piechcio@isb.com.pl
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dump with lo
2006-03-02 11:41 dump with lo Maciej Piekielniak <piechcio@isb.com.pl>
2006-03-02 15:21 ` Re: dump with lo Tom Lane <tgl@sss.pgh.pa.us>
2006-03-02 16:59 ` Re: dump with lo Maciej Piekielniak <piechcio@isb.com.pl>
@ 2006-03-17 15:50 ` Markus Schaber <schabi@logix-tt.com>
0 siblings, 0 replies; 4+ messages in thread
From: Markus Schaber @ 2006-03-17 15:50 UTC (permalink / raw)
To: Maciej Piekielniak <piechcio@isb.com.pl>; +Cc: pgsql-sql
Hi, Marciej,
Maciej Piekielniak wrote:
> TL> Use 8.1's pg_dump and pg_dumpall to dump from the old server. We fixed
> TL> that problem finally.
>
> I try to copy pg_wrapper,PgCommon.pm to /usr/bin but when i type
> pg_dump -V i got:
> Argument "." isn't numeric in numeric lt(<) at PgCommon.pm line 439
> Error: You must install at least one
> postgresql-client-<version>package
pg_wrapper etc. are debian specific and somewhat fragile if you don't
strictly obey the debian multi-cluster concept. Using a 8.1 client
against a 7.4 server is one of those problematic cases.
Install the postgresql-client-8.1 debian package and use
/usr/lib/postgresql/8.1/bin/psql directly.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-03-17 15:50 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-02 11:41 dump with lo Maciej Piekielniak <piechcio@isb.com.pl>
2006-03-02 15:21 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-03-02 16:59 ` Maciej Piekielniak <piechcio@isb.com.pl>
2006-03-17 15:50 ` Markus Schaber <schabi@logix-tt.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