Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Problem exporting Postgresql database
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
lazloman
Guru
Guru


Joined: 27 Dec 2003
Posts: 343
Location: Skokie, Il. USA

PostPosted: Tue Apr 19, 2005 1:50 pm    Post subject: Problem exporting Postgresql database Reply with quote

I want to dump my database using pg_dump, it fails. Here is the commandline and the error:

Hammer postgresql $ pg_dump --file=stats.out --format=t printstats

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of input node
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM pg_database WHERE datname = 'printstats'


I posted a message on the Postgresql mailing list and they say the build is at fault. Anyone have any ideas on how to fix this?
TIA
_________________
Gentoo x86
2x Dell Optiplex GX200

"My Break-Dancing days are over, but there's always the Funky Chicken."
--The Full Monty
Back to top
View user's profile Send private message
Petyr
Guru
Guru


Joined: 08 Jan 2003
Posts: 471
Location: San Diego, CA, USA

PostPosted: Tue Apr 19, 2005 9:28 pm    Post subject: Reply with quote

re-emerge postgres ^_~
Might want to take a look at your CFLAGS and perhaps make them a bit less agressive too.

Regards,
Petyr
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum