Re: BUG #2805: restore backup - Mailing list pgsql-bugs

From tomas@tuxteam.de
Subject Re: BUG #2805: restore backup
Date
Msg-id 20061204051912.GA14366@www.trapp.net
Whole thread Raw
In response to BUG #2805: restore backup  ("carmelo" <cmo1@libero.it>)
List pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Dec 02, 2006 at 06:44:23PM +0000, carmelo wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2805
> Logged by:          carmelo
> Email address:      cmo1@libero.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?

> 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/QBcgs9XrR2kYRApjCAJ94MCTfwyIuYBJY14gR12VP2X61eACfQssn
5Rqrjy8r0N741pxu/7/rZyA=
=UzD6
-----END PGP SIGNATURE-----

pgsql-bugs by date:

Previous
From: "Lucian Capdefier"
Date:
Subject: Re: BUG #2789: problem with delete statement
Next
From: Igor Shevchenko
Date:
Subject: Re: partial PGresult in pgsql v8.2rc1