Re: [ADMIN] RESOLVED: msi installer: CREATESERVICEUSER and uninstall

2007-06-25 Thread Dirk . Moebius
Just for the record: I solved the problem by checking myself whether the user 'postgres' actually exists before running the msi installer. I do this by running the following WSH script doing an ADO query: Private Function userExists ( ByVal domain, ByVal username ) ' checks whether a cert

[ADMIN] pgAdminIII via VPN

2007-06-25 Thread Jerry Crocker
I'm trying to configure pgAdminIII (version 1.6.3) via a Cisco VPN (version 4.8.02.0010) link. I've installed pgAdminIII on my laptop, and having connected to the client via Cisco VPN, I can't configure pgAdmin to connect (and the Help is not very helpful!) I can get to the Master via puTTY us

Re: [ADMIN] pgAdminIII via VPN

2007-06-25 Thread Adam Witney
But with puTTY you are connecting to the Master server via telnet/ssh and then connecting to PostgreSQL from that server. So PostgreSQL sees the connection as coming from the Master server, which is presumably allowed in your pg_hba.conf. When connecting directly to PostgreSQL from your laptop, yo

Re: [ADMIN] pgAdminIII via VPN

2007-06-25 Thread Vishal Arora
make an entry for your laptop IP in the pg_hba.conf file on the server. It would work. From: "Jerry Crocker" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: Subject: [ADMIN] pgAdminIII via VPN Date: Mon, 25 Jun 2007 11:06:22 +0100 I'm trying to configure pgAdminIII (version 1.6.3) via

[ADMIN] database creation date

2007-06-25 Thread Pradeep Chandru
Hi, I have two questions. 1. Is there a way to find the database creation time? 2. Is WAL implementation possible in postgres7.1.1? If so simple steps for the same? This is required to migrate from the older setup to the latest version in parallel without disturbing the current setup. Regards, P

[ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Mary Anderson
Hi all, I am new to postgresql and have been called upon to set up a database to be used by two groups. One group (mine) is strictly a UNIX shop. The other group (theirs) is strictly a Windows shop. What is the best way to go. First, does postgresql have replication and can i get it wi

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Shoaib Mir
Slony can handle this all. If you do not want to use Slony, you can write your own triggers using dblink module to get the data across. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 6/25/07, Mary Anderson <[EMAIL PROTECTED]> wrote: Hi all, I am new to postgresql and have been calle

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Chris Browne
[EMAIL PROTECTED] ("Shoaib Mir") writes: > Slony can handle this all. No it can't. It will not work with versions of PostgreSQL earlier than 7.3.3, because it requires namespace functionality that did not stabilize until that point. -- (reverse (concatenate 'string "moc.enworbbc" "@" "enworbbc")

Re: [ADMIN] database creation date

2007-06-25 Thread Chris Browne
[EMAIL PROTECTED] ("Pradeep Chandru") writes: > > > Hi, >

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Andrew Sullivan
On Mon, Jun 25, 2007 at 02:42:04PM -0400, Chris Browne wrote: > No it can't. It will not work with versions of PostgreSQL earlier > than 7.3.3, because it requires namespace functionality that did not > stabilize until that point. But if you're running on <7.3.3, you really, really need to upgrad

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Shoaib Mir
I didnt meant for the version, what i meant was all on latest. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 6/25/07, Chris Browne <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] ("Shoaib Mir") writes: > Slony can handle this all. No it can't. It will not work with versions of PostgreSQL

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Adam Radlowski
Mary Anderson wrote: Hi all, I am new to postgresql and have been called upon to set up a database to be used by two groups. One group (mine) is strictly a UNIX shop. The other group (theirs) is strictly a Windows shop. What is the best way to go. First, does postgresql have replicati