On Mon, 22 Apr 2013 12:06:52 -0600, Benjamin Krajmalnik wrote:
I currently have 2 servers running PostgreSQL 9.0 under FreeBSD
configured with streaming replication.
DB1 is the primary server, and DB2 is the replicated server, which is
used for all of the read only queries.
I am having
On Mon, 07 Jan 2013 14:35:48 -0700, Benjamin Krajmalnik wrote:
snip
What do you think you will gain by adding urgent to your subject line?
What do you think you will gain by posting in HTML?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
On Mon, 07 Jan 2013 14:35:48 -0700, Benjamin Krajmalnik wrote:
snip
What do you think you will gain by adding urgent to your subject line?
What do you think you will gain by posting in HTML?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
On Thu, 03 Jan 2013 16:24:17 +, Alcívar Arcos wrote:
(Quoted in full)
Postgres gentlemen good day, my question is very timely, I need to
migrate a system from Informix, PostgreSQL, what are the advantages
Postgres, and is there any tool to perform this migration?
thanks
Alcivar
On Sat, 08 Dec 2012 18:01:06 +, T.T Le wrote:
Hello,
We are running PostgresPlus 8.4AS on a linux system. I don't need to
edit the config files or to restart the clusters (the DBA will do that
for us).
I only need access to help troubleshoot performance issues with the
databases.
My
On Thu, 25 Oct 2012 15:29:29 +0200, jo wrote:
Hi all,
I'm working with same db schema in PostgreSQL and Oracle,
We mainly work in PostgreSQL but sometimes we need to copy schema and
data from pg to oracle because some our customers want to use oracle
instead of pg.
Thus I'm looking for
On Wed, 10 Oct 2012 14:15:15 -0700, Rosser Schwarz wrote:
Fellow Pg Admins,
At $work, we're preparing to move one of our Pg instances to new
hardware, and considering an OS upgrade at the same time. The instance
in question is running an older version of 8.3, which we'd like to
upgrade to
On Fri, 21 Sep 2012 10:33:25 -0600, Scott Marlowe wrote:
On Tue, Sep 11, 2012 at 2:48 PM, Vincent Dautremont
vinc...@searidgetech.com wrote:
Hi,
I'm using Postgresql 9.1.3 x64 on Windows 2008,
I'm doing reliability tests and effects and consequences of a server
power failure.
If you're
On Fri, 24 Aug 2012 10:35:54 -0400, Tom Lane wrote:
No route to host doesn't have anything to do with whether there's
anything listening on the target port ... what's more likely is that the
OP mistyped the IP address, or else there's something wrong with his
network layout, interface netmask
On Mon, 16 Apr 2012 16:27:38 -0700, ЇЯЅHAÐ wrote:
Hi,
We are trying to migrate from Postgres to Oracle, although our DB is
gigantic but we started on Mar 14th 2012 its still running with an
average of 40 records per day
400,000? That's pathetic. Why didn't you just use Postgres's copy
On Wed, 14 Mar 2012 13:24:36 +0200, Khangelani Gama wrote:
thanks, the issue we have is that we have many Linux users having root
access into the system. So they're able to access the DB by just going
in as su - superusername. If this user is able to make any updates
inside the database it
On Wed, 07 Mar 2012 10:39:48 -0500, Ray Stell wrote:
how I can differentiate these:
oamp=# \z public.c3*
Access privileges
Schema | Name | Type | Access privileges | Column
access privileges
On Mon, 13 Feb 2012 10:57:39 -0800, Dinesh Bhandary wrote:
Hello,
Has anyone done postgres logical backup (pg_dump) using Amanda (
Advanced Maryland Automatic Network Disk Archiver).
So far I have seen plugin for wall logging method, but have not found
any information on pg_dump. Is it
On Tue, 31 Jan 2012 13:41:00 +0530, Gnanakumar wrote:
Hi,
Our Production server is running PostgreSQL v8.2.22 on CentOS5.2. We
want to enable a specific CHECK constraint for our application table as
explained below:
There are 2 columns in the table: managertype numeric(1) and
managerid
On Mon, 16 Jan 2012 23:24:41 +0300, David M. Gullever wrote:
Question - user postgres
If the admin is creating various postgresql users to work on different
databases - is it advisable to create these as LINUX users so that
they have a home directory for saving their scripts - and while we
On Thu, 05 Jan 2012 10:22:59 -0600, Kevin Grittner wrote:
Tripura k_trip...@hotmail.com wrote:
I am trying to drop a schema by writing the following line
DROP SCHEMA xxx IF EXISTS
The syntax requires:
DROP SCHEMA IF EXISTS xxx;
I have two issues here -
1 I am not sure how to
On Wed, 07 Dec 2011 09:13:10 -0500, Gene Poole wrote:
This has to do with my personal home environment.
I'm running Oracle 11gR2 DBMS with 4 instances using a single home
directory. For each of the instances I'm using LVM file systems with 10
logical volumes defined (/dbmsu00 used for the
On Wed, 07 Dec 2011 21:22:05 +, jkells wrote:
I do not have a recent backup of this database/table
Any help would be appreciated.
Here's some help: Next time you establish a database, set up and test the
backup regime.
We hear this tale of woe time and time again. I have *no* sympathy.
On Wed, 07 Dec 2011 22:20:30 +, jkells wrote:
I am relying on identifying and correcting a bad block.
Well, good luck with that. Most of the time you can't. Just check your
disk, replace it if necessary, restore from your backup and roll forward.
Oh, you can't do that, since you didn't
On Tue, 29 Nov 2011 09:57:24 -0800, Kasia Tuszynska wrote:
Hi Everybody,
This is an architectural question.
I am testing on Postgres 9.0.2 on windows and linux(suse, rhel, ubuntu)
I want to make sure that I have the correct understanding of the
Postgres architecture and would like to
20 matches
Mail list logo