Hi,
I have two postmasters running,
and ps -aux shows two servers, but netstat shows
only one.
can some one show me what parameters to put on
netstat to show both,
one is tcp , the other is unix domain,
the tcp is invisible to netstat.
thanks.
paul
Paul Gimpelj [EMAIL PROTECTED] writes:
I have two postmasters running,
and ps -aux shows two servers, but netstat shows only one.
Perhaps one of them isn't configured to listen on TCP/IP?
regards, tom lane
---(end of
[EMAIL PROTECTED] writes:
I already specified the IP address that was specified by my VPN
connection.
This is a long shot, but ... did you remember to SIGHUP the postmaster
after editing pg_hba.conf to allow that IP address?
regards, tom lane
Yes sir, did that, too.
Thanks,
- Lily Anne
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 10:50 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [ADMIN] pg_hba.conf
[EMAIL PROTECTED] writes:
I
Hi all,
Running postgresql 7.1.3 on Solaris 9:
Restoring a database from a RH 7.3 Postgresql 7.1 version
Get the message:
CREATE SEQUENCE live_autoincrement start 1 increment 1 maxvalue
92233720368547
75807 minvalue 1 cache 1;
ERROR: parser: parse error at or near 9223372036854775807
(set
I am thinking that the entry for this ip has an issue with the username and/or
database specified in the line (or maybe conflicting entries?) Would you
mind posting your complete pg_hba.conf to the list?
Robert Treat
On Tuesday 25 May 2004 10:50, [EMAIL PROTECTED] wrote:
Yes sir, did that,
Here it is
Thanks! :)
-Original Message-
From: Robert Treat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 1:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [ADMIN] pg_hba.conf
I am thinking that the entry for this ip has an issue with the
Laurens Wagemakers [EMAIL PROTECTED] writes:
Running postgresql 7.1.3 on Solaris 9:
Restoring a database from a RH 7.3 Postgresql 7.1 version
You generally aren't going to be able to restore a dump into an older
version without some manual labor.
CREATE SEQUENCE live_autoincrement start 1
Um, I restarted postmaster so many times already after I made the entry
and this is the only pg_hba.conf file in our server (you're right,
$PGDATA/pg_hba.conf). It's a brand new server that had just been built.
Have you tried connecting to your pgSQL server via VPN?
Thanks!
-Original
Title: Database Size Limiting
Is there a way to limit the size that an individual database can take up?
My understanding is that all your databases go into a file system which is your catalog cluster.
But all the databases can grow until that filesystem is full.
Is there a way to limit
Or it might be a security issue with how our VPN is setup. I'll talk to
our security folks and see what they will find.
Thanks!
-Original Message-
From: Sanchez, Lily
Sent: Tuesday, May 25, 2004 2:55 PM
To: 'Tom Lane'
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Thanks Mike!
I already specified the IP address that was specified by my VPN
connection. I read through the docs and found nothing about anything
special with VPN connections.
Which address? The address at your end of the connection may not be
the same as the
Hmm
Looks like I am still in the same boat you are.
I still cannot log into my db over a VPN connection using pgadminIII.
Everytime I try and connect I get a Server terminated connection
unexpectedly error.
I originally received the pg_hba.conf entry complaint as well but after
adding and
On Wed, 11 Feb 2004, Mark Lubratt wrote:
Interesting discussions on IDE drives and their write caches.
I have a question...
You mentioned that you'd see the problem during a large number of
concurrent transactions. My question is, is this a necessary condition
for the database
Hello,
I believe I found my problem. The Cisco VPN client I use encrypts data
at a 168 bit level. Postgres only supports up to 128 bit correct?
Mike
On Tue, 2004-05-25 at 23:12, mike g wrote:
Hmm
Looks like I am still in the same boat you are.
I still cannot log into my db over a
please remove my list form email listy I do not want to get emails.
_
Plan your next US getaway to one of the super destinations here.
http://special.msn.com/local/hotdestinations.armx
---(end of
16 matches
Mail list logo