Re: Connection string

Поиск
Список
Период
Сортировка
От Harpreet Dhaliwal
Тема Re: Connection string
Дата
Msg-id d86a77ef0608092102l179b8c7epcd4f4497dafa8e5c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Connection string  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: Connection string
Список pgsql-general
Дерево обсуждения
Hi
I already read that documentation.
 
My ECPG code for connecting to the DB server is:
 
EXEC SQL CONNECT TO 192.168.1.100:/xyz
 
i also tried
 

  • tcp:postgresql://192.168.1.100[:port][/dbname][ ?options]

  • unix:postgresql://192.168.1.100[:port][ /dbname][?options]


    but unfortunately it say DB doesn't exist.
     
    I don't know the right way to use IP addresses while connecting to a postgres DB using ECPG.
     
    On 8/9/06, Michael Fuhr <mike@fuhr.org> wrote:
    On Wed, Aug 09, 2006 at 11:02:00AM -0400, Harpreet Dhaliwal wrote:
    > I'm trying to connect to postgres database in  a distributed environment,
    > say from machine X to Machine Y (Machine Y has postgres DB)
    > How should my connection string look like in a program in Machine X.
    >
    > EXEC SQL CONNECT TO ------??? (Do i need to specify the IP of DB server?)
    > I tried a few options but nothing works.

    This appears to be ECPG so see "Connecting to the Database Server"
    in the ECGP chapter of the documentation:

    http://www.postgresql.org/docs/8.1/interactive/ecpg-connect.html

    If the documentation and examples don't help then please post exactly
    what you've tried and what happened (complete error message, etc.).

    --
    Michael Fuhr

В списке pgsql-general по дате отправления: