Обсуждение: non TCP connection

Поиск
Список
Период
Сортировка

non TCP connection

От
Alex Perry
Дата:
How do I tell the "new server" dialog that I want to use a UNIX
socket to connect to the database server instead of TCP loopback?


Re: non TCP connection

От
"Dave Page"
Дата:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Alex Perry
> Sent: 20 July 2005 07:19
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] non TCP connection
>
> How do I tell the "new server" dialog that I want to use a UNIX
> socket to connect to the database server instead of TCP loopback?

UDS support is only available in the development snapshots at present,
however, from the docs:


The address is the IP address of the machine to contact, or the fully
qualified domain name. On Unix based systems the address field may be
left blank to use the default PostgreSQL Unix Domain Socket on the local
machine, or be set to an alternate path containing a PostgreSQL socket.
If a path is entered, it must begin with a "/".

Regards, Dave.


Re: non TCP connection

От
Tino Wildenhain
Дата:
Am Dienstag, den 19.07.2005, 23:18 -0700 schrieb Alex Perry:
> How do I tell the "new server" dialog that I want to use a UNIX
> socket to connect to the database server instead of TCP loopback?

Unfortunately it seems not implemented - I was stuck at the same
problem some days ago when I tried out a local database for
some tests.

-- 
Tino Wildenhain <tino@wildenhain.de>



Re: non TCP connection

От
Alex Perry
Дата:
> Alex Perry asked:
> > How do I tell the "new server" dialog that I want to use a UNIX
> > socket to connect to the database server instead of TCP loopback?

Dave quickly answered:
> UDS support is only available in the development snapshots at present

Thank you.  I'll try checking out from SVN and building for Debian/Sarge.



Debian/Stable can't build rereqs for svn tree

От
Alex Perry
Дата:
Alex promised:
> Dave quickly answered:
> > Alex Perry asked:
> > > How do I tell the "new server" dialog that I want to use a UNIX
> > > socket to connect to the database server instead of TCP loopback?
> > UDS support is only available in the development snapshots at present
> Thank you.  I'll try checking out from SVN and building for Debian/Sarge.

Checked out, installed most build prerequisites, and encountered:http://www.pgadmin.org/download.php#source
> Requirements: ...
> * wxWidgets 2.6.0. Currently, this is the only version we support.

They've released 2.6.1 ... I pulled that down but it doesn't build,
at least not with Debian/Stable and GCC version 3.3 or 3.4 as below,
so I'll either stick with released pgadmin or use another approach.
I'm including the actual error from the build for completeness below;
this is _not_ a request that someone figure out what went wrong.

Dave, again, thank you for your quick and helpful response above.


./bk-deps gcc-3.4 -c -o corelib_msgout.o  -D__WXGTK__   \
-I./src/tiff -I./src/jpeg -I./src/png   -I./src/regex  -DwxUSE_BASE=0 \
-D__WXDEBUG__ -Ilib/wx/include/gtk2-unicode-debug-static-2.6 -I./include \
-DXTHREADS -pthread -I/usr/include/gtk-2.0 -I/usr/lib/gtk-2.0/include \
-I/usr/X11R6/include -I/usr/include/atk-1.0 -I/usr/include/pango-1.0 \
-I/usr/include/freetype2 -I/usr/include/glib-2.0 \
-I/usr/lib/glib-2.0/include -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES \
-D_LARGEFILE_SOURCE=1 -g -O0 -pthread -Wall -Wno-ctor-dtor-privacy 
...
./src/common/msgout.cpp
In file included from ./include/wx/event.h:32,                from ./include/wx/app.h:20,                from
./src/common/event.cpp:40:
./include/wx/cursor.h:24:31: wx/gtk/cursor.h: No such file or directory
In file included from ./include/wx/event.h:32,                from ./include/wx/app.h:20,                from
./src/common/event.cpp:40:
./include/wx/cursor.h: In destructor `wxBusyCursorSuspender::~wxBusyCursorSuspender()':
./include/wx/cursor.h:70: error: invalid use of undefined type `const struct wxCursor'
./include/wx/gdicmn.h:36: error: forward declaration of `const struct wxCursor'
In file included from ./include/wx/event.h:32,                from ./include/wx/app.h:20,                from
./src/common/msgout.cpp:41:
./include/wx/cursor.h:24:31: wx/gtk/cursor.h: No such file or directory
In file included from ./include/wx/event.h:32,                from ./include/wx/app.h:20,                from
./src/common/msgout.cpp:41:
./include/wx/cursor.h: In destructor `wxBusyCursorSuspender::~wxBusyCursorSuspender()':
./include/wx/cursor.h:70: error: invalid use of undefined type `const struct wxCursor'In file included from
./include/wx/app.h:20,               from ./src/common/event.cpp:40:
 
./include/wx/event.h: At global scope:
./include/wx/event.h:933: error: field `m_cursor' has incomplete type
./include/wx/event.h: In constructor `wxSetCursorEvent::wxSetCursorEvent(wxCoord, wxCoord)':
./include/wx/event.h:912: error: class `wxSetCursorEvent' does not have any field named `m_cursor'
./include/wx/event.h: In copy constructor `wxSetCursorEvent::wxSetCursorEvent(const wxSetCursorEvent&)':
./include/wx/event.h:919: error: class `wxSetCursorEvent' does not have any field named `m_cursor'
./include/wx/event.h:919: error: 'const class wxSetCursorEvent' has no member named 'm_cursor'
./include/wx/event.h: In member function `void wxSetCursorEvent::SetCursor(const wxCursor&)':
./include/wx/event.h:925: error: `m_cursor' undeclared (first use this function)
./include/wx/event.h:925: error: (Each undeclared identifier is reported only once for each function it appears in.)
./include/wx/event.h: In member function `const wxCursor& wxSetCursorEvent::GetCursor() const':
./include/wx/event.h:926: error: `m_cursor' undeclared (first use this function)
./include/wx/event.h: In member function `bool wxSetCursorEvent::HasCursor() const':
./include/wx/event.h:927: error: `m_cursor' undeclared (first use this function)