On Sat, Feb 23, 2013 at 12:55:07AM -0500, Charles Sprickman wrote:
>[...]
>The one huge downside to this is that the logs are so noisy, it's
>hard to track down errors and stats real-time since the query logging
>is so noisy.
> [...]
>Right now I'm considering just switching to syslog-ng or rsyslog
Hi,
I have an application that requires to connect to each database available
in PostgreSQL. I have the following questions:
1. Is there a USE DATABASE command or something of the sort (similar to
MySQL) that allows you to quickly connect to a database without having to
reconnect using the
On 02/25/2013 10:22 AM, Frank Cavaliero wrote:
Hi,
I have an application that requires to connect to each database
available in PostgreSQL. I have the following questions:
1. Is there a USE DATABASE command or something of the sort (similar to
MySQL) that allows you to quickly connect to a d
Hi Adrian,
Thanks for the response. The situation is more like the following:
Using the JDBC driver, I connect to database TEST1 and immediately,
without having to pass username credentials again, I want to use database
TEST2. In MySQL, you can simply run: use TEST2. Wondering if
Postgre
On 02/25/2013 10:57 AM, Frank Cavaliero wrote:
Hi Adrian,
Thanks for the response. The situation is more like the following:
Using the JDBC driver, I connect to database TEST1 and immediately,
without having to pass username credentials again, I want to use
database TEST2. In MySQL, you can
On Mon, Feb 25, 2013 at 01:57:11PM -0500, Frank Cavaliero wrote:
> Hi Adrian,
>
> Thanks for the response. The situation is more like the following:
>
> Using the JDBC driver, I connect to database TEST1 and immediately,
> without having to pass username credentials again, I want to use databa
Hi Adrian,
Thanks a lot!I will certainly look into the multiple datasources as an
option.
-Frank
From:
Adrian Klaver
To:
Frank Cavaliero/Boston/IBM@IBMUS
Cc:
pgsql-admin@postgresql.org, pgsql-gene...@postgresql.org
Date:
02/25/2013 02:16 PM
Subject:
Re: [GENERAL] Use, Set Catalog a
On 02/25/2013 11:21 AM, Frank Cavaliero wrote:
Hi Adrian,
Thanks a lot!I will certainly look into the multiple datasources as
an option.
Just remember, as John pointed out, a MySQL database and a Postgres
database are not equivalent. You will not be able to do cross database
operations(
Hi, I'm trying to test restoration of a database using point-in-time
recovery. I'm taking a backup of the database using pg_basebackup:
pg_basebackup -D /postgres/data -Fp -l RestorePostgres -U reco -w -h
radmast01 -p 5432
Then attempting to recover the backup on a second server using the followin
