dbTalk Databases Forums  

[BUGS] BUG #2805: restore backup

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2805: restore backup in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
carmelo
 
Posts: n/a

Default [BUGS] BUG #2805: restore backup - 12-03-2006 , 01:25 PM







The following bug has been logged online:

Bug reference: 2805
Logged by: carmelo
Email address: cmo1 (AT) libero (DOT) it
PostgreSQL version: 7.4.7
Operating system: linux 2.4.2 debian
Description: restore backup
Details:

Dear all,
I've update postgresql from postgresql_7.2.1-2_i386.deb to 7.4.7-6sarge3 and
now I would restore my old data (pg_dump bombole > db_bombole_01dic06),
seems it work but when I try to do:
cat db_bombole_01dic06 | psql bombole or
psql -f db_bombole_01dic06 bombole or
psql bombole < db_bombole_01dic06
I get only the table but not the data inside it, why?

Waiting for your reply, thank you in advance

Kind regards
Carmelo

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
  #2  
Old   
tomas@tuxteam.de
 
Posts: n/a

Default Re: [BUGS] BUG #2805: restore backup - 12-03-2006 , 11:36 PM






-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Dec 02, 2006 at 06:44:23PM +0000, carmelo wrote:
Quote:
The following bug has been logged online:

Bug reference: 2805
Logged by: carmelo
Email address: cmo1 (AT) libero (DOT) it
PostgreSQL version: 7.4.7
Operating system: linux 2.4.2 debian
Description: restore backup
Details:

Dear all,
I've update postgresql from postgresql_7.2.1-2_i386.deb to 7.4.7-6sarge3 and
now I would restore my old data (pg_dump bombole > db_bombole_01dic06),
seems it work but when I try to do:
cat db_bombole_01dic06 | psql bombole or
psql -f db_bombole_01dic06 bombole or
psql bombole < db_bombole_01dic06
Any error messages here?

Quote:
I get only the table but not the data inside it, why?
Have you looked into db_bombole_01dic06? Is there any data in there?

We need to know more to be able to help you :-)

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFc6/QBcgs9XrR2kYRApjCAJ94MCTfwyIuYBJY14gR12VP2X61eACfQ ssn
5Rqrjy8r0N741pxu/7/rZyA=
=UzD6
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.