On 08/15/2014 01:52 PM, AlexK wrote:
To deploy my changes, I am using apgdiff. For that, I am invoking the
following command:
pg_dump --host=my_dev_server --username=myself --no-password --schema-only
--file=C:\Temp\mydb_old.sql my_test_db
Two objects are present in my test database, but not i
To deploy my changes, I am using apgdiff. For that, I am invoking the
following command:
pg_dump --host=my_dev_server --username=myself --no-password --schema-only
--file=C:\Temp\mydb_old.sql my_test_db
Two objects are present in my test database, but not in the dump file. I can
invoke them from
Hi,
we have weird situation today.
Pg 9.1.13, on ubuntu, on AWS.
At ~ 7am one of db servers stopped responding, and got restarted using AWS
console.
After reboot everything seemed to work fine.
But later on I found that one of the segments was not archived.
Segment ...7 was written (mtime of f
I can't offer a whole lot of detail at this point, but I experienced a
pretty bad caching issue about 2 years ago using XFS.
We were migrating a 1TB+ Oracle database to EDB's Advanced server 9.1
(Close enough for this discussion). I normally use ext4, but decided to try
XFS for this build-out.
Thi
-Original Message-
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: 15 August 2014 17:06
To: Russell Keane
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Upgrading 9.0 to 9.3 - permission denied to
pg_upgrade_utility.log
On Tue, Aug 12, 2014 at 10:59:16AM +0100, Russell Kea
On Tue, Aug 12, 2014 at 10:59:16AM +0100, Russell Keane wrote:
> > The upgrade works all the way up until the final hurdle where, in the
> > pg_upgrade_utility.log the following statement appears:
> >
> > command: ""C:\Program Files (x86)\PostgreSQL\9.3\bin/initdb"
> > --sync-only "D:\ PostgreSQ
Hi -
I have a table with a citext[] column, and I'm trying to write a
uniqueness constraint for the array values. That is, two rows with
{one,two} and {two,three} would conflict. Since it's citext, also
{one,two} and {TWO, THREE} should conflict too.
My first thought was to make a unique index us
Thanks Melvin, That worked for me. Great.
From: Melvin Davidson
[mailto:melvin6...@yahoo.com]
Sent: 15 August 2014 15:46
To: farjad.fa...@checknetworks.com;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] list of index
>On a Postgresql database i like to obtain (using
an s
Hi ,
I have done that. The important point is obtaining the “sort order” of each
column in the index. Specially multi column index.
Are there no views?
How does the engine handle sort order of a multi column index?!!
>From what I have seen it is rather complicated in postgres.
On 15 August 2014 16:23, FarjadFarid(ChkNet) wrote:
> Hi ,
>
>
>
> On a Postgresql database i like to obtain (using an sql statement) the
> list of all user defined indexes and their details specially the column
> "order by" sort order. e.g. ASC or DESC. Any help would be much
> appreciated.
>
>
Hi ,
On a Postgresql database i like to obtain (using
an sql statement) the list of all user defined
indexes and their details specially the column
"order by" sort order. e.g. ASC or DESC. Any help
would be much appreciated.
Hi
On the 1st of July 2014 Jacob Bunk Nielsen wrote:
> We have a PostgreSQL 9.3.4 running in an LXC container on Debian
> Wheezy on a Linux 3.10.43 kernel on a Dell R620 server. Data are
> stored on a XFS file system. We are seeing problems such as:
>
> unexpected data beyond EOF in block 2 of r
12 matches
Mail list logo