Re: BUG #2805: restore backup

From: tomas(at)tuxteam(dot)de
To: carmelo <cmo1(at)libero(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2805: restore backup
Date: 2006-12-04 05:19:13
Message-ID: 20061204051912.GA14366@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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?

> 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-----

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Igor Shevchenko 2006-12-04 09:07:20 Re: partial PGresult in pgsql v8.2rc1
Previous Message Lucian Capdefier 2006-12-03 22:15:00 Re: BUG #2789: problem with delete statement