| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgres question |
| Date: | 2020-11-06 22:05:08 |
| Message-ID: | 5a135ef0-b970-9a69-f721-6c8b825755ba@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
Of course pg_dump can also dump blobs, and it's even the default. You
may use the option --no-blobs to leave them out.
A glance at the man page can be more informative than just hearing
something from someone.
Regards,
Holger
Am 06.11.20 um 23:02 schrieb Ron Watkins:
> Newbie to postgres here. We have Postgres 11 server at work and we
> need to copy a database contents from a TEST server to a PROD server.
> I was looking at pg_dump, but I heard it doesn't work with binary
> (blob) data? Can someone clarify how to copy a database contents from
> one server to another server?
> Ron
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
| Attachment | Content-Type | Size |
|---|---|---|
| OpenPGP_0x8A579C93B31961BA.asc | application/pgp-keys | 16.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-11-06 22:07:43 | Re: Postgres question |
| Previous Message | Ron Watkins | 2020-11-06 22:02:06 | Postgres question |