Re: Postgres backup & restore

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres backup & restore
Date: 2019-04-16 17:54:03
Message-ID: 20190416175403.GN2854@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Apr 16, 2019 at 05:41:31PM +0000, Daulat Ram wrote:
> postgres=# \l
> kb_rep | postgres | UTF8 | C.UTF-8 | C.UTF-8 |

> postgres(at)b06a42b503e9:/$ pg_restore -h 10.29.50.21 -p 5432 -d kb_rep -v /var/lib/kb_rep_backup16
> pg_restore: [archiver (db)] connection to database "kb_rep" failed: FATAL: database "kb_rep" does not exist

Are you sure this DB is the one running on 10.29.50.21 port 5432 ?

Justin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2019-04-16 19:28:40 Re: Out of Memory errors are frustrating as heck!
Previous Message Daulat Ram 2019-04-16 17:41:31 Postgres backup & restore