![]() This parameter is ignored if an SSL connection is not made. .postgresql/postgresql.crt if pgAdmin is installed ~/.postgresql/postgresql.crt if pgAdmin is installed in Desktop mode, and Use the Client certificate field to specify the file containing the client Icon that is located to the right of each of the following fields. To access the File manager dialog, click the Platform-specific File manager dialog to upload files that support SSLĮncryption to the server. If pgAdmin is installed in Server mode (the default mode), you can use the Section 33.18 of the Postgres documentation. Use the drop-down list box in the SSL field to select the type of SSLĬonnection the server should use. Use the fields in the SSL tab to configure SSL: You can also write the name of the known publication in the field. Click on the refresh button at the end to load the names of the existing publications and then select from the list. Use the Publication field to specify the publication name on the publishers to subscribe to. For more information, see Section 33.15 of the Postgres documentation. pgpass file allows a user to login without providing a password when they connect. Use the Passfile field to specify the location of a password file (.pgpass). It is not recommended to use a timeout of less than 2 seconds. Zero or not specified means wait indefinetly. Use the Connection timeout field to specify the maximum wait for connection, in seconds. Use the Database field to connect to the database in which publication is residing. Use the Password to provide the password of the user. Use the Username field to provide the name of the user to connect to the publication. Use the Port field to provide port number to connect at Postgres Server in which publication is residing. Use the Host name/address field to provide the valid hostname or ip address of the publication. Use the Connection tab to define the connection string to the publisher: ![]() Please note that owner of the subscription has superuser privileges. You can change the owner after creating subscription using alter subscription. The Owner field takes the name of the user automatically as current connected user. The name will be displayed in the pgAdmin tree control. Use the Name field to add a descriptive name for the subscription. ![]() Use the fields in the General tab to identify the subscription: The SQL tab displays the SQL code generated by dialog selections. The subscription dialog organizes the development of a subscription through the following dialog tabs: General, Connection and With. A subscription defines the connection to another database and set of publications (one or more) to which it wants to subscribe. Use the Subscription dialog to create a subscription.
0 Comments
Leave a Reply. |