Thread: Re: [ADMIN] pg_dump error
Hi Joshua, Thanks for your reply. No, I recently installed (fresh installation) from scratch. Regards skarthi >From: "Joshua D. Drake" <jd@commandprompt.com> >To: Karthikeyan Sundaram <skarthi98@hotmail.com> >CC: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org >Subject: Re: [ADMIN] pg_dump error >Date: Wed, 28 Feb 2007 11:31:01 -0800 > >Karthikeyan Sundaram wrote: > > Hi, > > > > I am using 8.2.1 on my dev server. > > > > When I do a pg_dump, I am getting an error message. > > > > pg_dump -U postgres podcast -t channel > > > > pg_dump: symbol lookup error: pg_dump: undefined symbol: >PQescapeStringConn > > > > How can I resolved this? What may be the problem? > > > > Because of this, I am not able to dump anything. > >Sounds like you have two different versions of pg_dump on your box. Did >you recently try to upgrade? > >Sincerely, > >Joshua D. Drake > > > > > > > > Regards > > skarthi > > > > _________________________________________________________________ > > Play Flexicon: the crossword game that feeds your brain. PLAY now for > > FREE. >http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > >-- > > === The PostgreSQL Company: Command Prompt, Inc. === >Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 >Providing the most comprehensive PostgreSQL solutions since 1997 > http://www.commandprompt.com/ > >Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate >PostgreSQL Replication: http://www.commandprompt.com/products/ > > >---------------------------(end of broadcast)--------------------------- >TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate _________________________________________________________________ Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117
Hi,
I have to dump only 10 tables out of 100 tables. In the pg_dump utility
given by postgres there is an option called -t followed by table name.
In that option, if I give more than 1 table, it's not accepting.
How can I get the dump in one stroke for all the 10 tables? Please
advise.
Regards
skarthi
_________________________________________________________________
Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month.
Intro*Terms
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117
Karthikeyan Sundaram escreveu: > Hi, > > I have to dump only 10 tables out of 100 tables. In the pg_dump > utility given by postgres there is an option called -t followed by table > name. > > In that option, if I give more than 1 table, it's not accepting. > > How can I get the dump in one stroke for all the 10 tables? Please > advise. > http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html "Multiple tables can be selected by writing multiple -t switches. Also, the table parameter is interpreted as a pattern according to the same rules used by psql's \d commands (see Patterns), so multiple tables can also be selected by writing wildcard characters in the pattern." []s Osvaldo _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/
On Thu, 2007-03-01 at 12:30 -0300, Osvaldo Rosario Kussama wrote: > http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html > "Multiple tables can be selected by writing multiple -t switches. Also, > the table parameter is interpreted as a pattern according to the same > rules used by psql's \d commands (see Patterns), so multiple tables can > also be selected by writing wildcard characters in the pattern." But note that this is a new feature in 8.2. In 8.1 and earlier, multiple -t switches will only get you the last one specified. Joe
"Karthikeyan Sundaram" <skarthi98@hotmail.com> writes:
> Thanks for your reply. No, I recently installed (fresh installation)
> from scratch.
Well, your pg_dump seems to be finding an older version of libpq.so from
somewhere. Check for a pre-existing postgresql package.
regards, tom lane