| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Juliano <jplinux(at)protonmail(dot)com> |
| Cc: | Francisco Olarte <folarte(at)peoplecall(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Overwrite pg_catalog? |
| Date: | 2016-12-06 10:21:20 |
| Message-ID: | CAB7nPqQ6ONfnwbenadjg=mpLiLa4L5GXbUDauTi09tz37-NU9w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 6, 2016 at 5:15 PM, Juliano <jplinux(at)protonmail(dot)com> wrote:
> Hi everyone,
>
> Ok, thanks.
> Just to explain: I have some custom objects on my pg_catalog and I would
> like to restore it in a new test database and I think that this is the best
> way, isn't it?
Yes, pg_dump and pg_dumpall are the tools to use to restore a database
or multiple databases from a past state, and provides options
regarding what you want to dump. So go for it.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Swapnil Vaze | 2016-12-06 10:26:56 | Re: Migrating data from DB2 zOS to PostgreSQL |
| Previous Message | Artur Zakirov | 2016-12-06 09:39:03 | Re: Install pgAudit extension |