On 6/16/17 01:09, Charles wrote:
> The suggestion was based on how pg_restore behaved when used this way
> (as user postgres on a Debian Jessie server):
>
> $ dropdb redmine_default
> $ pg_restore --create --dbname=postgres
> redmine_default-2017-06-11@18\:21\:06.sql
If you are using the --create option, you get a different behavior.
This is pretty explicitly described on the pg_restore man page under
--describe.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services