--- On Tue, 3/15/11, H S wrote:
From: H S
Subject: Re: [ADMIN] createdb does not work?!
To: "dhaval jaiswal"
Date: Tuesday, March 15, 2011, 9:31 AM
in one terminal I have recieved this notes:
LOG: database system was shut down at 2011-03-15 07:56:00 EDT
LOG: autovacuum launcher started
LO
Try following command
createdb -h -p -U [DBNAME]
psql -d [DBNAME] -U
Date: Mon, 14 Mar 2011 21:39:17 -0700
From: aras_h1...@yahoo.com
Subject: [ADMIN] createdb does not work?!
To: pgsql-admin@postgresql.org
Dear Sirs,
After this command , what I should do?
Can not use createdb te
> The key to understanding the problem is to realize that system
> catalogs are pretty much regular tables in PostgreSQL, with some
> additional special rules (no triggers, can't be CLUSTERed or ALTERed,
> &c). Anything you'd do in a regular table that would create a dead
> tuple UPDATEs, DELETE
Dear Sirs,
After this command , what I should do?
Can not use createdb test command and psql test.
I installed correctly postgres by source code.
[postgres@localhost bin]$ ./postgres -D /usr/local/pgsql/data
LOG: database system was shut down at 2011-03-15 07:56:00 EDT
LOG: autovacuum la
On Mon, 2011-03-14 at 20:04 -0700, H S wrote:
> Kevin,
>
> What did you mean by "OP"?
It means "Original Poster"
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.
Kevin,
What did you mean by "OP"?
Did you look at veil?
http://veil.projects.postgresql.org/curdocs/index.html
(This was mentioned earlier, but the OP didn't respond to that.)
Thanks,
Sara
--- On Thu, 3/10/11, Kevin Grittner wrote:
From: Kevin Grittner
Subject: Re: [ADMIN] Oracle
(Apologies for thread-jacking; I saw something similar in the OP's
description of his setup that I thought warranted a word of advice.)
On Mon, Mar 14, 2011 at 1:50 AM, Gnanakumar wrote:
> Do you think that this "significantly bloated system catalogs" is caused
> because of the old version 8.2.3
[getting back to the original question]
"Gnanakumar" wrote:
> in order to monitor the growth (table size) of temporary tables
> created while report is running, we've a "separate Java standalone
> program" which automatically executes the following query every 5
> minutes and keeps writing out
"Gnanakumar" wrote:
> Instead of touching/refactoring all the 35 functions just to
> rename the table name, we decided to create the temporary table
> name same as that of existing permanent table for running this
> complex report alone
If it were me I would be running some global search and r
> From: Lukasz Brodziak
> Subject: [ADMIN] Dropping all constraints in database
> To: pgsql-admin@postgresql.org
> Date: Monday, 14 March, 2011, 9:26
> Hello,
>
> Is there a way of disabling/dropping all constrainsts in a
> given
> database? I need to restore a db which has duplicate values
> in
Lukasz Brodziak, 14.03.2011 10:26:
Hello,
Is there a way of disabling/dropping all constrainsts in a given
database? I need to restore a db which has duplicate values in nearly
half of its tables then remove duplicates and then add the constraints
back. Is there a way to do that for each table i
Hello,
Is there a way of disabling/dropping all constrainsts in a given
database? I need to restore a db which has duplicate values in nearly
half of its tables then remove duplicates and then add the constraints
back. Is there a way to do that for each table in one
statement/function? It may be e
Hi,
We're using PostgreSQL v8.2.3. Ours is a web-based application, language is
Java and we're using pgpool-II v 2.0.1 purely for connection pooling (we
don't use other features of pgpool like Replication, Load Balancing, etc.).
We're creating temporary table using "CREATE TEMP TABLE FOO(col1, c
> Although it's unrelated to your query about an exception being raised,
> a word of advice on temporary tables. (This may not be relevant to
> your situation, but it's no small source of pain in one of the systems
> I'm responsible for.) Significant use of temporary tables will cause
> commensur
On Sun, Mar 13, 2011 at 11:59 PM, Gnanakumar wrote:
[...]
Although it's unrelated to your query about an exception being raised,
a word of advice on temporary tables. (This may not be relevant to
your situation, but it's no small source of pain in one of the systems
I'm responsible for.) Signi
15 matches
Mail list logo
