What exactly do you mean ? Upgrade libraries which postgres depends on
while the server is running ? Depends on the distro I think. I did
this with gentoo, e.g. upgrade glibc while postgres (and other
services) still use the old version. Except from memory issues (both
versions have to be kept in m
Any comment about this?
Regards...
From: fabrix...@hotmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] mapping libraries
Date: Thu, 10 Feb 2011 18:19:33 -0700
Hi...
If i can't upgrade a server with postgres 8.1 and at this time i can't delete a
super user, Is there any way to avoid
When I used pg_dump then after few minutes it shows error
This probably means the server terminated abnormally before or while
processing the request. pg_dump: The command was: FETCH 100 FROM
_pg_dump_cursor
Before 2 month backup running normal. But few month Backup only done 869Mb
after
On Mon, Feb 14, 2011 at 11:05 AM, Bryan Keller wrote:
> Thanks for the feedback. It sounds like NFS is a viable solution nowadays. I
> a still going to shoot for using iSCSI, given it is a block-level protocol
> rather than file-level, it seems to me it would be better suited to database
> I/O.
Thanks for the feedback. It sounds like NFS is a viable solution nowadays. I a
still going to shoot for using iSCSI, given it is a block-level protocol rather
than file-level, it seems to me it would be better suited to database I/O.
On Feb 14, 2011, at 2:07 AM, Stuart Bishop wrote:
> On Thu, F
Hi Devrim,
Thanks for the reply. I've managed to get it working though.
Regards,
- Jaya -
2011/2/14 Devrim GÜNDÜZ
> On Mon, 2011-02-14 at 13:54 +0800, Jayaraj Nagaraj wrote:
> >
> > I have installed Posgresql 9.0 onto my Ubuntu 10.04 system, and runs
> > perfectly. I installed it via the Ubut
You write trigger for integrity
--
pasman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Am Donnerstag, den 10.02.2011, 17:56 +0100 schrieb Bernhard Schrader:
> Hi all,
>
> I just tried to pg_upgrade a PostgreSQL-8.4 to 9.0.
>
> pg_upgrade stopped with this message:
>
> "old and new cluster lc_collate values do not match"
>
> So i checked the LC_COLLATE on 8.4 and 9.0:
>
> 8.4:
>
I have a requirement.
Created table called a.
CREATE TABLE a(no int primary key,name text);
Need to create reference key for no field of array. which is belongs to b
table.
The postgresql is not allowing to create a reference for incompatible type.
CREATE TABLE d(no int[] references a,name
I have a requirement.
Created table called a.
CREATE TABLE a(no int primary key,name text);
Need to create reference key for no field of array. which is belongs to b
table.
The postgresql is not allowing to create a reference for incompatible type.
CREATE TABLE d(no int[] references a,name
I haven't solved my problem yet. Can anybody give me a hint ?
best regards
El 11/02/2011 12:33, Stefanie Weykam escribió:
Hi list members,
I ran into a similar problem as these ones:
http://archives.postgresql.org/pgadmin-support/2010-09/msg6.php
http://postgresql.1045698.n5.nabble.com/pgAdm
On Thu, Feb 10, 2011 at 2:59 AM, Bryan Keller wrote:
> I am considering running a Postgres with the database hosted on a NAS via
> NFS. I have read a few things on the Web saying this is not recommended, as
> it will be slow and could potentially cause data corruption.
Its not recommended if y
On Mon, 2011-02-14 at 13:54 +0800, Jayaraj Nagaraj wrote:
>
> I have installed Posgresql 9.0 onto my Ubuntu 10.04 system, and runs
> perfectly. I installed it via the Ubutu repo (apt-get install).
> However, I am trying to get the PgPool working as well. I am trying
> 'make' one of the component f
13 matches
Mail list logo
