Re: regarding dblink_fdw

2018-08-02 Thread Tom Lane
=?utf-8?q?PG_Doc_comments_form?=  writes:
> * dblink_fdw data wrapper does not seem to be available by default with
> postgresql10
> * dblink_fdw extension does not seem to be distributed with postgresql10
> * dblink_fdw extension does not seem to be mentioned in appendix F.
> Additional Supplied Modules.

dblink_fdw is provided by the dblink extension.  There's an example
of how to use it in the dblink docs.

Depending on whose packaging you're using, you might need to install
a "contrib" subpackage to get access to the appendix-F modules.

If you've successfully created the dblink extension in a given
database, and yet you still don't see any dblink_fdw, you might
need to "alter extension update" to bring dblink to something
newer than 1.0.

regards, tom lane



user issue

2018-08-02 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/tutorial-createdb.html
Description:

I ran "createdb mydb" but putting in my password I got "createdb: could not
connect to database template1: FATAL:  password authentication failed for
user '(LOCAL USER)' "
Running "createdb -U postgres mydb" works with my password. Installation
seems to have created the user postgres without warning, but cmd and psql
both assume local user as default.