| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Maciej Piekielniak <piechcio(at)isb(dot)com(dot)pl> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: dump with lo |
| Date: | 2006-03-17 15:50:09 |
| Message-ID: | 441ADAB1.5050507@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2006-03-17 17:52:53 | in PlPgSQL function, how to use variable in a "select ... into .. where " query |
| Previous Message | Stefan Meyer | 2006-03-17 13:39:04 | rowcount for all tables |