Re: [ADMIN] setting up ODBC

You can also use netstat to see if it is listening. Postgres usually listens on port 5432 right? so examine netstat -na and see if anything is listening on tcp port 5432. If you are using a recent version of linux, netstat has the -p option that will name the process listening on that port. Oth

Re: [ADMIN] setting up ODBC

> ... I am still getting the following error when trying to connect: > ODBC--call failed > could not connect to the server > could not connect to remote socket #101 > > any thoughts? Try psql -h localhost on the server witth postgres. If that fails then you know you have a sockets problem and n

[ADMIN] PostgreSQL/Mac OS X GUI management tools

Hi, Since PGAccess is not an option on Mac OS X due to problems getting non frameworks-based tk to work (somebody correct me if I'm wrong) I thought people might be interested to know that there are a few GUI tools that allow PostgreSQL database management on Mac OS X. The first, MacSQL, h

[ADMIN] setting up ODBC

Thanks to those that have responded to my issue. I have done all that I think was recommended:   My Windows workstation has the psqlODBC driver I added ODBC extensions to the base catalogs I added the -i switch to my postmaster startup in order to turn on TCPIP connections I modified my pg_h

Re: [ADMIN] setting up ODBC

Jodi- Take a look at the section titled "Configuring Postgresql for JDBC" on this page: http://www.fankhausers.com/postgresql/jdbc/#driver_install Although the instructions are intended for JDBC, I believe the IP connection part is the same. -Nick -Original Message- From: [EMAIL PROT

Re: [ADMIN] setting up ODBC

> I am trying to connect to postgres via ODBC so that I can use Visio. I have >installed psqlODBC on my windows 2000 workstation and am trying to get to our >postgres database located on a Linux machine. > Do I need to enable ODBC on the Linux side? or just configure the driver on my >workstati

[ADMIN] setting up ODBC

I am trying to connect to postgres via ODBC so that I can use Visio. I have installed psqlODBC on my windows 2000 workstation and am trying to get to our postgres database located on a Linux machine. Do I need to enable ODBC on the Linux side? or just configure the driver on my workstation? I

Re: [ADMIN] problems with postgresql speed

On Mon, 3 Dec 2001, Manuel Trujillo wrote: > SELECT d.gallery_id, e.subevent_id, d.result_type_id, > d.result_type_name, e.language_id FROM ((SELECT b.gallery_id, > b.element_id AS result_type_id, c.name AS result_type_name FROM > gallery_element b, result_type c WHERE ((c.id = b.element_id) AND

Re: [ADMIN] problems with postgresql speed

I know someone already pointed out the cache differences between the processors, and that is likely to contribute to the differences you have observed. As was stated in the message about cache, databases are extremely IO bound. It is worth noting that Celeron's have a Front Side Bus speed of 66

Re: [ADMIN] compression -Fx "problem"

Manuel Trujillo <[EMAIL PROTECTED]> writes: > The program tell me a "warning" like this: > Archiver: WARNING - requested compression not available in this > installation - archive will be uncompressed > What I make to do for obtain the necessary compression for the "-Fc" > flag and work after with

[ADMIN] compression -Fx "problem"

Hi. I has compiled a postgresql 7.1.3 into a Debian GNU/Linux. The "configure" option has the 'max-backends', 'enable-locale' and 'enable-syslog' options. When I make a: pg_dump -O -x -Fc > backupdatabase.sql The program tell me a "warning" like this: Archiver: WARNING - requested compr