Обсуждение: BUG #2805: restore backup

Поиск
Список
Период
Сортировка

BUG #2805: restore backup

От
"carmelo"
Дата:
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
I get only the table but not the data inside it, why?

Waiting for your reply, thank you in advance

Kind regards
Carmelo

Re: BUG #2805: restore backup

От
tomas@tuxteam.de
Дата:
-----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-----