Hello,
a few months ago we started using Postgres on Opensuse10.3-64bit.
We installed Postgres 8.3.1 with the (at that time) latest available rpm's.
But now Postgres' current version is 8.3.4 and I'm wondering why there
are no new rpm's for Opensuse ?!?!
The suse build service still offers me 8.3.
I do not know what was the question and what was the answer :(
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Joshua Drake <[EMAIL PROTECTED]> writes:
> kevin kempter <[EMAIL PROTECTED]> wrote:
>> ... I got this far (see
>> below) however this query produces additional rows with attname's
>> like tableoid, cmax, xmax ctid, etc.
>>
>> select attname from pg_attribute where attrelid = (select oid from
>>
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> Does anyone know if there's plans afoot to add this to 8.4 psql as a
> \d command? Seems it could be useful. Heck, if there was just a bit
> more data in the \dT output we'd be set.
Done already, see \dT+ ...
regards, tom lan
On Mon, 22 Sep 2008 16:06:06 -0600
kevin kempter <[EMAIL PROTECTED]> wrote:
> Hi List;
>
> I want to pull the list of column names from the system catalogs for
> a specified table. I only want column names, I want to exclude any
> index names, or other non-column name rows. I got this far (see
>
Hi List;
I want to pull the list of column names from the system catalogs for a
specified table. I only want column names, I want to exclude any index
names, or other non-column name rows. I got this far (see below)
however this query produces additional rows with attname's like
tableoid
Many thanks, Scott!
Tena
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Mon 9/22/2008 11:21 AM
To: Tena Sakai
Cc: [email protected]
Subject: Re: [ADMIN] question on pg_ctl
On Mon, Sep 22, 2008 at 11:49 AM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Hi Ever
On Mon, Sep 22, 2008 at 11:49 AM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Hi Everybody,
>
> I want to change a line in postgresql.conf (shared_buffers)
> and then issue a command:
> pg_ctl reload
>
> This forces the postmaster process to reread the configuration
> file with new shared_buffer valu
Hi Everybody,
I want to change a line in postgresql.conf (shared_buffers)
and then issue a command:
pg_ctl reload
This forces the postmaster process to reread the configuration
file with new shared_buffer value. And the postgres process
that comes to life from this point on will execute with t
As Tom mentioned, it sounds like you're being bitten by the oom
killer. If, for some reason, you cannot run with it turned off, then
add a really big swap space so it delays the onset of sudden death by
oom to something really big.
Is It possible your work_mem is set too high?
--
Sent via pgsql
Does anyone know if there's plans afoot to add this to 8.4 psql as a
\d command? Seems it could be useful. Heck, if there was just a bit
more data in the \dT output we'd be set.
On Mon, Sep 22, 2008 at 8:53 AM, <[EMAIL PROTECTED]> wrote:
> Assuming you are are running 8.3, you can do this:
>
>
On Mon, 2008-09-22 at 17:06 +0200, Tino Schwarze wrote:
>
> As far, as you do not really use SIGKILL (9), but SIGTERM (15),
> everything should be fine.
Yea my bad -- SIGTERM not SIGKILL.
Thanks for confirming.
A nice little SQL macro would be awesome: DISCONNECT or TERMINATE
But handling it v
--- On Mon, 9/22/08, Jagadeesh <[EMAIL PROTECTED]> wrote:
> From: Jagadeesh <[EMAIL PROTECTED]>
> Subject: [ADMIN] displaying enum
> To: [email protected]
> Date: Monday, September 22, 2008, 1:20 PM
> Hi admins,
>
> I had created enum and forgotten what were the values. Is
> there any
>
On Mon, Sep 22, 2008 at 09:43:29AM -0400, Brian A. Seklecki wrote:
BTW: What version of PG are you using?
> We need to kill apache P-conn pools from a an application/web server
> cluster for a specific database. We use a load-balancer, so we shut
> down the HA L4 Service VIP that the web servers
Assuming you are are running 8.3, you can do this:
SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where
a.oid=b.enumtypid and a.typname='NAME_OF_ENUM';
Chirag Dave
Afilias
On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <[EMAIL PROTECTED]> wrote:
> Hi admins,
>
> I had created enum and for
"Vladimir Rusinov" <[EMAIL PROTECTED]> writes:
> But now I'm getting following error:
> pg_dump: WARNING: terminating connection because of crash of another server
> process
As a rule of thumb, you should disable OOM kill on any server system.
However, you might want to look into why the system's
Hi admins,
I had created enum and forgotten what were the values. Is there any
way to see what I created?
Thanks
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi.
First of all, sorry for my English. I hope you'll understand me.
We have quite large database: about 10G with two tables with binary data (~7
Gb and ~2 Gb with 1-5 Mb rows, there are no rows bigger than 6 MBytes).
We have 8 Gb ram, enough swap and 32-bit RHEL4 (I know, this is not very
good)
This one really isn't in the docs, so we'll add it to the Wiki
afterwords, but:
We've got some shared PG instances with more than one production
application (yes, I know this is a bad practice, but virtualization
options are hit and miss).
We need to kill apache P-conn pools from a an application
Hello,
we've been reported a problem with installing PostgreSQL v8.2.9 via ICA-Client
- initdb failed with error code 128. Installation of v8.3 and strangely v8.1
was no problem.
It seems to be an older problem:
http://archives.postgresql.org/pgsql-hackers-win32/2004-08/msg00288.php
Did you cha
20 matches
Mail list logo
