From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Postgres question
Date: Fri, 6 Nov 2020 23:05:08 +0100
Message-ID: <5a135ef0-b970-9a69-f721-6c8b825755ba@jakobs.com> (raw)
In-Reply-To: <CAPdrarq+tNYUJMPTPfTwQhXphv7+Yxme6E2+iRnv9z595zetpg@mail.gmail.com>
References: <CAPdrarq+tNYUJMPTPfTwQhXphv7+Yxme6E2+iRnv9z595zetpg@mail.gmail.com>
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
Attachments:
OpenPGP_0x8A579C93B31961BA.asc (application/pgp-keys, 16.5K) download
OpenPGP_signature (application/pgp-signature, 202B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgres question
In-Reply-To: <5a135ef0-b970-9a69-f721-6c8b825755ba@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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