pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestore and Backup PG8.4 tp 9.4
4+ messages / 3 participants
[nested] [flat]
* Restore and Backup PG8.4 tp 9.4
@ 2015-08-17 08:42 Mohamed MANSOUR <med.mnsour@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Mohamed MANSOUR @ 2015-08-17 08:42 UTC (permalink / raw)
To: pgsql-admin
hi ,
i have been restoring my old server pg8.4 with this command in Ubuntu 15.04
*pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f
"10.70.0.61.backup" **myDb*
i try to import this backup in my new server pg 9.4 with this command
*pg_restore -i -h localhost -p 5432 -U postgres -d **myDb** -v
"10.70.0.61.backup"*
the backup worked fine but in restoring i get this error !
*pg_restore: connecting to database for restore*
*pg_restore: [archiver (db)] connection to database "**myDb**" failed:
FATAL: Ident authentication failed for user "postgres"*
*pg_restore: *** aborted because of error*
what is the problem please ?
--
*Mohamed MANSOUR*
Eléve Ingenieur / Développeur .Net
( + 216 ) 52 958 794
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Restore and Backup PG8.4 tp 9.4
@ 2015-08-17 11:04 Ville Rantamaula <ville.rantamaula@gmail.com>
parent: Mohamed MANSOUR <med.mnsour@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Ville Rantamaula @ 2015-08-17 11:04 UTC (permalink / raw)
To: Mohamed MANSOUR <med.mnsour@gmail.com>; +Cc: pgsql-admin
Hi,
I'd guess you would have to first allow the user 'postgres' localhost
access to your database 'myDb'.
Check the configuration file pg_hba.conf for access control, and you
probably need to add a line there. In Ubuntu the file is probably located
under the directorry /var/lib/postgresql/9.3/main/.
Yours,
Ville
2015-08-17 11:42 GMT+03:00 Mohamed MANSOUR <med.mnsour@gmail.com>:
> hi ,
>
> i have been restoring my old server pg8.4 with this command in Ubuntu
> 15.04
>
> *pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f
> "10.70.0.61.backup" **myDb*
>
> i try to import this backup in my new server pg 9.4 with this command
>
> *pg_restore -i -h localhost -p 5432 -U postgres -d **myDb** -v "10.70.0.61.backup"*
>
> the backup worked fine but in restoring i get this error !
>
> *pg_restore: connecting to database for restore*
> *pg_restore: [archiver (db)] connection to database "**myDb**" failed:
> FATAL: Ident authentication failed for user "postgres"*
> *pg_restore: *** aborted because of error*
>
>
> what is the problem please ?
> --
> *Mohamed MANSOUR*
> Eléve Ingenieur / Développeur .Net
> ( + 216 ) 52 958 794
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Restore and Backup PG8.4 tp 9.4
@ 2015-08-17 14:46 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
parent: Mohamed MANSOUR <med.mnsour@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Jan-Peter Seifert @ 2015-08-17 14:46 UTC (permalink / raw)
To: pgsql-admin
Hello,
Am 17.08.2015 um 10:42 schrieb Mohamed MANSOUR:
> i try to import this backup in my new server pg 9.4 with this command
>
> |*pg_restore -i -h localhost -p 5432-U postgres -d **myDb**-v
> "10.70.0.61.backup"*|
>
> the backup worked fine but in restoring i get this error !
>
> *pg_restore: connecting to database for restore*
> *pg_restore: [archiver (db)] connection to database "**myDb**" failed:
> FATAL: Ident authentication failed for user "postgres"*
> *pg_restore: *** aborted because of error*
I guess you have to use sudo:
http://wiki.ubuntuusers.de/postgresql
Regards,
Peter
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Restore and Backup PG8.4 tp 9.4
@ 2015-08-17 15:10 Mohamed MANSOUR <med.mnsour@gmail.com>
parent: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
0 siblings, 0 replies; 4+ messages in thread
From: Mohamed MANSOUR @ 2015-08-17 15:10 UTC (permalink / raw)
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; +Cc: pgsql-admin
it worked fine after adding acces role in the pg_hba.conf !!
thanks @Ville
2015-08-17 15:46 GMT+01:00 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>:
> Hello,
>
> Am 17.08.2015 um 10:42 schrieb Mohamed MANSOUR:
>
> > i try to import this backup in my new server pg 9.4 with this command
> >
> > |*pg_restore -i -h localhost -p 5432-U postgres -d **myDb**-v
> > "10.70.0.61.backup"*|
> >
> > the backup worked fine but in restoring i get this error !
> >
> > *pg_restore: connecting to database for restore*
> > *pg_restore: [archiver (db)] connection to database "**myDb**" failed:
> > FATAL: Ident authentication failed for user "postgres"*
> > *pg_restore: *** aborted because of error*
>
> I guess you have to use sudo:
> http://wiki.ubuntuusers.de/postgresql
>
> Regards,
>
> Peter
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
*Mohamed MANSOUR*
Eléve Ingenieur / Développeur .Net
( + 216 ) 52 958 794
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2015-08-17 15:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-08-17 08:42 Restore and Backup PG8.4 tp 9.4 Mohamed MANSOUR <med.mnsour@gmail.com>
2015-08-17 11:04 ` Ville Rantamaula <ville.rantamaula@gmail.com>
2015-08-17 14:46 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2015-08-17 15:10 ` Mohamed MANSOUR <med.mnsour@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox