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
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
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 b
On Thu, 05 Jan 2012 10:22:59 -0600, Kevin Grittner wrote:
> Tripura 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 s
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 w
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
>
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 i
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 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
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
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 ne
On Fri, 21 Sep 2012 10:33:25 -0600, Scott Marlowe wrote:
> On Tue, Sep 11, 2012 at 2:48 PM, Vincent Dautremont
> 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 looking to tes
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
> upgra
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 looki
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
On Sun, 23 Dec 2012 11:08:32 -0500, Kevin Grittner wrote:
> Kong Man wrote:
>
>> The postgresql.conf file has always been using the default value, which
>> is 'warning'.
>
> Maybe it's not using the postgresql.conf file you think it is. Does this
> show the file you've been looking at?:
>
> SHO
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
>
> Alciv
On Mon, 07 Jan 2013 14:35:48 -0700, Benjamin Krajmalnik wrote:
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 subscription:
On Mon, 07 Jan 2013 14:35:48 -0700, Benjamin Krajmalnik wrote:
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 subscription:
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 ha
On Tue, 01 Oct 2013 08:17:37 -0600, Andrew Swartzendruber wrote:
> Would it be possible to prevent the system from forgetting the stored
> password when pgAdmin fails to connect in a future release or have an
> option that would prevent forgetting of passwords?
>
> I use pgAdmin 1.16 or 1.18 to c
22 matches
Mail list logo
