Re: [ADMIN] DBLink

2013-04-25 Thread Rob Richardson
Isn't that basically what replication is supposed to do? RobR, quite possibly revealing his ignorance about replication. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Where do I get pgAgent now?

2011-12-02 Thread Rob Richardson
I've seen lots of questions about this on the Internet, but no answers. I've got PostgreSQL 8.4 and 9.1 both installed on my computer. I am trying to set up a scheduled database job to support application testing. The problem is that I do not seem to have any of the files required to install p

Re: [ADMIN] transaction error handling

2011-11-30 Thread Rob Richardson
Very naïve question here: Why would you want to save the data from the first insert? I thought the purpose of a transaction was to make sure that all steps in the transaction executed, or none of them executed. If Oracle saves half of the data between the beginning and ending of the transact

[ADMIN] Postgres ODBC driver 8.04 installation recovery path

2011-03-25 Thread Rob Richardson
Greetings! I want to install the Postgres ODBC driver version 8.04 for a customer that is currently using 8.01. However, I cannot make any change to the customer's computer without being able to undo the change in case something goes wrong. The customer has a spare computer that we have been

[ADMIN] Do I need to run pgagent_upgrade.sql? If so, when?

2011-01-10 Thread Rob Richardson
Greetings! I am putting together a formal installation package for a customer who is not happy if he doesn't have one, even though he's got primary and backup servers both running as expected. I am writing instructions on how to install PGAgent. The download package for PGAgent includes

Re: [ADMIN] fail-safe sql update triggers

2010-09-03 Thread Rob Richardson
I thought I sent this earlier, but it's not in my Sent box, so I'll try again. Your solution maintains an exact copy of two tables. Whenever a record is updated in the first, it is updated in the second, and you have lost information about the previous value. Whenever I do anything like this,

[ADMIN] PgsqlODBC 8.1 and 8.4 side-by-side installation

2010-07-07 Thread Rob Richardson
I have a customer who is running PostgreSQL 8.1. I recently updated an application there, and it is running extremely slowly. The previous version of the application runs fine, and the new version runs fine on my machine, which runs PostgresQL 8.4. The problem is that a query for a single record

[ADMIN] BackupExec stops PostgreSQL service

2010-06-10 Thread Rob Richardson
Greetings! In an attempt to satisfy our client's requirements for redundancy, we ended up with an unusual (at least to my inexperienced eyes) system configuration. Our client has two buildings that use our application. Each building has an application server and a storage server. All are runnni