On 4 May 2012 14:55, Vincent de Phily wrote:
> It all seems to be working fine, except that when checking the data (selecting
> latest primary key and sequence value for all tables) on master and slave,
> some sequence ids are higher on the slave than on the master. I could
> understand if they w
Hi. Does anybody here know how to add comments to the SQL standard?
I believe this would benefit lots of people.
Situation: When a system administrator or database administrator looks at
a gnarly SQL query chewing up system resources, there is no way to tell
by looking at the query server-side w
Aleksey Tsalolikhin wrote on 06.05.2012 19:24:
Situation: When a system administrator or database administrator looks at
a gnarly SQL query chewing up system resources, there is no way to tell
by looking at the query server-side which application it came from, what its
purpose is, and who the au
Hi,
Is there a tool for checking a postgresql database for integrity, so I
would be notified immediatly if something went wrong e.g. with memory
and can go back to the last good backup?
Such a tool would guarantee me I am not sitting on a ticking time bomb
(corrupted database) without even noticin
Thomas Kellerer writes:
> Aleksey Tsalolikhin wrote on 06.05.2012 19:24:
>> Situation: When a system administrator or database administrator looks at
>> a gnarly SQL query chewing up system resources, there is no way to tell
>> by looking at the query server-side which application it came from, w
Hi,
On 6.5.2012 20:47, Clemens Eisserer wrote:
> Hi,
>
> Is there a tool for checking a postgresql database for integrity, so I
> would be notified immediatly if something went wrong e.g. with memory
> and can go back to the last good backup?
> Such a tool would guarantee me I am not sitting on a
On Mon, May 07, 2012 at 12:37:47AM +0200, Tomas Vondra wrote:
> Hi,
>
> On 6.5.2012 20:47, Clemens Eisserer wrote:
> > Hi,
> >
> > Is there a tool for checking a postgresql database for integrity, so I
> > would be notified immediatly if something went wrong e.g. with memory
> > and can go back t
On 7.5.2012 00:56, Bruce Momjian wrote:
> On Mon, May 07, 2012 at 12:37:47AM +0200, Tomas Vondra wrote:
>> Hi,
>>
>> On 6.5.2012 20:47, Clemens Eisserer wrote:
>>> Hi,
>>>
>>> Is there a tool for checking a postgresql database for integrity, so I
>>> would be notified immediatly if something went w
Thank you Laurenz for your answer.
I think I understand the meaning of ORDER BY my problem is the
understanding of COLLATE functionality. I thought that if I collate in es.PE
(Spanish) the "o" has the exact value of "รณ" so if I
INSERT INTO pru VALUES (8, 'leo','zara', 'juan');
How can I obtain
On Sat, May 5, 2012 at 4:19 PM, Stefan Tzeggai wrote:
> Hi
>
> postgresql 9.1 on Ubuntu 10.04
>
> All important information is in the other tablespaces. I would be
> totally happy to just loose all relations in that lost tablespace. It's
> just indexes. Is there any way to tell PG to drop/ignore t
10 matches
Mail list logo
