By default the postmaster in Windows
listens for TCP/IP connections only on the loopback interface.
Take a look at your conf files (postgresql.conf
and pg_hba.conf). Postgresql.conf probably needs to have a line added something
like this:
listen_addresses = '*' #
what IP inte
Behalf Of Bender, Cheryl
Sent: Wednesday, September 29, 2004 11:01 AM
To: Magnus Hagander; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [ADMIN] TCP/IP access in Postgresql 8 Windows
<>
This is not bourne out by my experience or the document you referenced.
The document and postgresq
<>
This is not bourne out by my experience or the document you referenced.
The document and postgresql.conf both state that the default is
'localhost' and only allows local loopback connections.
For some reason the author of postgresql.conf did not follow the
convention of putting the commented d
Werner;
Activating tcp/ip listening is different than 7.*. You need to
uncomment the following line in your postgresql.conf and change it to
listen on a specified interface or '*' for all interfaces.
Listen_addresses='*'
Then restart the service.
Another very useful parameter on Windows to c
Title: Message
When
starting the Windows psql client I get a warning that the
"console codepage (437) differs from the windows codepage (1252)" and
to see installation on Windows for details. I am having trouble finding
this documentation. I've also been looking for the "Windows FAQ"
whi
Title: Message
Are
you sure there is current activity on your backend when you are running this
query? I get the same result because there are no queries
executing.
Cheryl Bender
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Monica LiberoSen
I apologize if this answer is in the archives but my search did not
reveal it.
I need to add an alternate db location for my 7.3.4 server (running on
FreeBSD 5.2 Release)
I thought I did everything according to the administrator's guide, but I
fail at createdb.
I completed the following:
---
Title: Message
A few
things I would do;
1. As other replies have mentioned check the port. If you
want to use 6432 I believe you have to put that in your conf
file
2. You need another line in your pg_hba.conf that provides access
to the network or specific IP and netmask of the computer
ECTED]
Subject: Re: [ADMIN] Dumping partial database content
Martha Stewart called it a Good Thing when [EMAIL PROTECTED]
("Bender, Cheryl") wrote:
> Just wondering--is it possible to dump on a temporary table?
The temp table is only visible inside the context of the transaction
Never mind--answered my own question.
You can dump from a temporary table, which provides Hanan another way to
dump a subset of data.
Use CREATE TEMPORARY TABLE as select
Cheryl Bender
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bender
Just wondering--is it possible to dump on a temporary table?
Cheryl Bender
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of mike g
Sent: Thursday, July 01, 2004 11:11 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Dumping partial data
Gene;
This is probably not much help but I was able to create and run this
function on 7.3.2 (running on FreeBSD 5.1) verbatim from your message.
Perhaps the function is corrupted? Maybe try dropping and recreating
the function.
Of course you wouldn't be able to factorial anything bigger than ab
<>
The easiest way is to set it in postgresql.conf, which is put in your
data folder when you run initdb.
Near the beginning of the file you should see something like
tcpip_socket=true
port=5432
Except that these lines are commented out by default. Uncomment them
and restart pgsql after saving
Dojie;
Have you already tried the solution below (from archives)?
**
Re: [pgadmin-support] pgAdmin II connection error
From: Dave Page
Michael;
What version of FreeBSD? What version of PostGres?
On my server, running FreeBSD 5.1 and pg 7.3, the values are
kern.ipc.shmmax: 33554432
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 8192
kern.ipc.shm_use_phys: 0
shm3035K 38K 4653 16,102
Hello all;
I am trying to connect to a postgreSQL server running version 7.3.2 on
freebsd (5.1). I'm having trouble getting the syntax right for this
subnet. I thought I had this working at home for a simple
192.168.0.0/24 network. This is the line in the pg_hba.conf
host all all 10.1
16 matches
Mail list logo
