can't connect using the -host option
От | Robert Wagner |
---|---|
Тема | can't connect using the -host option |
Дата | |
Msg-id | 852568C0.00622D74.00@SIAC_NOTES_001.wisdom.siac.com обсуждение исходный текст |
Ответы |
Re: can't connect using the -host option
|
Список | pgsql-general |
Dear All, Strange behaviour.... I'm working in a TCL environment and use pg_connect to connect to pgsql databases. I want to move a suite of apps into production testing. I need to be able to run an app on any workstation, and connect to a database on any workstation on our tcp-ip network. For example, the development database might be on one host, but the production and QA databases on another. And I might want to test any database interactively... However, even if the database is ON my current workstation, I can ONLY connnect with the command, "pg_connect dbName". If I use the -host option, I get the error: Error: Connection to database failed User Authentication failed ... strange indeed. Suggestions on making this work? Also, when I started up an identical database on a different workstation, even with a different port, it caused my original database on my home server to cease accepting connections. All suggestions are welcome. If I ask for help from Unix Admin, they'll tell us that we have to migrate to one of their "supported" databases, such as Sybase... something I 'd like to avoid!! Cheers Rob
В списке pgsql-general по дате отправления: