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
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.
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 ,
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.
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 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
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
-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
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
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
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
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
12 matches
Mail list logo
