From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | tmickol(at)combimatrix(dot)com, Postgres Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: editing postgresql.conf for network access |
Date: | 2001-06-04 12:50:58 |
Message-ID: | 20010604125058.13185.qmail@web13408.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks! That did the network trick.
For anyone who uses ODBC to access PostgreSQL and is
upgrading to PostgreSQL 7.1.*: you may have to
upgrade your ODBC driver. The driver that comes in
the old postdrv.exe file can connect to the database;
but displays an empty list of tables. The newer
version, psqlodbc-07_01_0005.zip, seems to work.
Have a great day!
Andrew Gould
--- Tim Mickol <tmickol(at)combimatrix(dot)com> wrote:
> (i.e., UNCOMMENT and change to true to enable
> distributed postgres
> capabilities)
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf
> Of Tim Mickol
> Sent: Sunday, June 03, 2001 7:38 PM
> To: Andrew Gould; Postgres Mailing List
> Subject: RE: [GENERAL] editing postgresql.conf for
> network access
>
>
> in postgresql.conf, find the entry:
>
> #tcpip_socket = false
>
> and modify it to
>
> tcpip_socket = true
>
> (i.e., comment and change to true to enable
> distributed postgres
> capabilities)
>
> this is the equivalent of the cmdline "-i" option
>
> good luck!
>
>
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf
> Of Andrew Gould
> Sent: Sunday, June 03, 2001 6:21 PM
> To: Postgres Mailing List
> Subject: [GENERAL] editing postgresql.conf for
> network access
>
>
> I have PostgreSQL 7.1.1 running on FreeBSD 4.3. The
> startup script uses pg_ctl; and instructs users to
> edit /usr/local/pgsql/data/postgresql.conf to change
> startup options. I've looked at the file; and am
> not
> sure how to change the connection parameters. (I'm
> assuming that I can't just type '-i' and expect it
> to
> work.) I've already edited the host access
> configuration file.
>
> Any help would be appreciated.
>
> Thanks,
>
> Andrew
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail -
> only $35
> a year! http://personal.mail.yahoo.com/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Brent R. Matzelle | 2001-06-04 13:45:16 | CHAR vs VARCHAR w/TOAST |
Previous Message | Francesco Casadei | 2001-06-04 10:48:51 | Re: PostgreSQL security concerns |