BUG #16062: pg_restore using ssl certs

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: somesh(dot)ng(at)gmail(dot)com
Subject: BUG #16062: pg_restore using ssl certs
Date: 2019-10-17 07:12:01
Message-ID: 16062-2cb787113ba2d0ed@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16062
Logged by: Somesh ng
Email address: somesh(dot)ng(at)gmail(dot)com
PostgreSQL version: 10.0
Operating system: Ubuntu
Description:

Can somebody help me in restoring postgres db using SSL certs. I tried in
below way but it didn't work

pg_restore "host=hostname user=username dbname=database_name
sslcert=sslcert.crt sslkey=sslkey.key sslrootcert=sslroot.pem
sslmode=verify-full" -f filename
It gives the below error

pg_restore: [archiver] could not open input file "host=hostname
user=username dbname=database_name sslcert=sslcert.crt sslkey=sslkey.key
sslrootcert=sslroot.pem sslmode=verify-full": No such file or directory

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-10-17 07:59:24 BUG #16063: Error retrieving data from the server: INTERNAL SERVER ERROR: string indices must be integers
Previous Message Michael Paquier 2019-10-17 05:40:57 Re: BUG #16049: log_line_prefix=%a and log_connections - application_name missing