pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedThe option was not described: connection-option
4+ messages / 3 participants
[nested] [flat]
* The option was not described: connection-option
@ 2024-09-19 16:46 PG Doc comments form <noreply@postgresql.org>
0 siblings, 2 replies; 4+ messages in thread
From: PG Doc comments form @ 2024-09-19 16:46 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: konkove@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/app-pgdump.html
Description:
Hi.
The option `connection-option` is mentioned but is not described.
Please describe it.
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: The option was not described: connection-option
@ 2024-09-19 17:06 Eugen Konkov <konkove@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
1 sibling, 1 reply; 4+ messages in thread
From: Eugen Konkov @ 2024-09-19 17:06 UTC (permalink / raw)
To: konkove@gmail.com; pgsql-docs@lists.postgresql.org
Also I have issue with this command:
pg_dump -d 'postgresql://postgres@host.internal?sslmode=require' --create
--clean --if-exists mydb
pg_dump: error: too many command-line arguments (first is "userdb")
pg_dump: hint: Try "pg_dump --help" for more information.
I want to connect to 'postgres' database and dump 'mydb', because database
was turned to readonly mode and does not accept connections:
pg_dump -d 'postgresql://postgres@host.internal/userdb?sslmode=require'
--create --clean --if-exists
pg_dump: error: connection to server at "host.internal" (172.31.x.x), port
5432 failed: FATAL: database "mydb" is not currently accepting connections
Please note, this is not the question and I am not looking for help. Here I
want to share my use case which is not covered in doc. Eg `-d XXX` option
with `dbname` parameter.
On Thu, Sep 19, 2024 at 12:47 PM PG Doc comments form <
noreply@postgresql.org> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/app-pgdump.html
> Description:
>
> Hi.
>
> The option `connection-option` is mentioned but is not described.
>
> Please describe it.
> Thanks.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: The option was not described: connection-option
@ 2024-09-19 17:47 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
1 sibling, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2024-09-19 17:47 UTC (permalink / raw)
To: konkove@gmail.com; pgsql-docs@lists.postgresql.org
On Thu, Sep 19, 2024 at 10:31 AM PG Doc comments form <
noreply@postgresql.org> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/app-pgdump.html
> Description:
>
> Hi.
>
> The option `connection-option` is mentioned but is not described.
>
> Please describe it.
>
>
They are described though the terminology is a bit inconsistent:
<command> also accepts the following command-line arguments for connection
parameters:
The items listed beneath that sentence fragment are the connection-options.
If someone wants to go, IMO, busy-fix all of the pages that use the above
wording to better align with the synopsis I won't argue. But it's low on
my priority list.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: The option was not described: connection-option
@ 2024-09-19 17:50 David G. Johnston <david.g.johnston@gmail.com>
parent: Eugen Konkov <konkove@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2024-09-19 17:50 UTC (permalink / raw)
To: Eugen Konkov <konkove@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org
On Thu, Sep 19, 2024 at 10:31 AM Eugen Konkov <konkove@gmail.com> wrote:
>
> I want to connect to 'postgres' database and dump 'mydb', because database
> was turned to readonly mode and does not accept connections:
>
This is fundamentally impossible by the design of the system. You can only
dump the database you connect to.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-09-19 17:50 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-19 16:46 The option was not described: connection-option PG Doc comments form <noreply@postgresql.org>
2024-09-19 17:06 ` Eugen Konkov <konkove@gmail.com>
2024-09-19 17:50 ` David G. Johnston <david.g.johnston@gmail.com>
2024-09-19 17:47 ` David G. Johnston <david.g.johnston@gmail.com>
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