Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Patric Michael: "Thank you for a wonderful product, and all the hard work you've obviously taken".
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".

More

Add your opinion

Customers
Download Buy

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Foreign Servers

A Foreign Server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource. Additional user-specific connection information may be specified by means of user mappings. PostgreSQL Maestro supports only the postgres_fdw foreign data wrapper. Creating a server requires USAGE privilege on the foreign-data wrapper being used.

 

To add a new foreign server,

•select the Foreign servers list or any object from that list in the explorer tree;
•use the Create New Foreign Server ... item from the popup menu or press Ins;
•specify options of this table in the Create Foreign Server Wizard.

 

The basic principles of Create Object Wizards in PostgreSQL Maestro are explained in a separate topic. Below you will find a description of wizard steps that are unique for the current object.

 

To change an existing foreign server, open the corresponding editor, modify necessary properties and click Apply changes.

 

Name

The server name must be unique within the database.

 

Owner

The owner of a foreign server can create user mappings for that server for any user. Also, a user can create a user mapping for his own user name if USAGE privilege on the server has been granted to the user.

 

Options

This clause specifies the options for the server. The options typically define the connection details of the server, but the actual names and values are dependent on the server's foreign-data wrapper. Postgres_fdw foreign data wrapper supports libpq options, except the following ones:

•user and password (specify these for a user mapping, instead)
•client_encoding (this is automatically set from the local server encoding)
•fallback_application_name (always set to postgres_fdw)

 

 

Type

Optional server type, potentially useful to foreign-data wrappers.

 

Version

Optional server version, potentially useful to foreign-data wrappers.



Prev Return to chapter overview Next