On Sep 21, 2006, at 6:40 AM, Jose Manuel Garci a Valladolid wrote:
I have a PostgreSQL 8.1.4 server under Linux Red Hat with several
databases. The server is configured with WAL archiving turned on.
As a maintenance process, every night one cron job launches a
backup process to the server wi
On Sep 21, 2006, at 1:53 PM, Thomas Vatter wrote:
When connection to the server with pgadmin3 there is a warning:
"The server lacks instrumentation functions ..."
There may be something wrong with my installation.
The server is version 8.1.4, it is the version for sles9 downloaded as
rpms from su
On Sep 20, 2006, at 5:32 AM, Boguk Maxim wrote:
Hm i have no idea how to rewrite 'OR' conditions with subqueries as
joins
(exept using 'UNION' as writen end of my message)
Are you sure it is possible?
WHERE
(parent_id IN (SELECT tt.id FROM el_comment as tt WHERE
tt.user_id=112 AND tt.statu
On Sep 20, 2006, at 11:45 AM, Jessica Richard wrote:
\l and \l+ show only the database name, owner and description.
select * from pg_database does not have date info, either.
I would like to know when each of my databases were created.
You're not the first person to ask for this, but it's sti
When connection to the server with pgadmin3 there is a warning:
"The server lacks instrumentation functions ..."
There may be something wrong with my installation.
The server is version 8.1.4, it is the version for sles9 downloaded as
rpms from suse.
---(end of broadcast
http://www.postgresql.org/docs/8.1/static/diskusage.html can help you get this information.Thanks,-- Shoaib MirEnterpriseDB (
www.enterprisedb.com)On 9/21/06, Guido Barosio <[EMAIL PROTECTED]> wrote:
there used to be a dbsize project, search for it.g.-On 9/21/06, Rodrigo Sakai <[EMAIL PROTECTED]> w
when you have dbsize installed you need to do
select relation_size('TableName');
to get the size of the table.
On 9/21/06, Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
Hello all,
I need a tool or something like it, which can give me the estimated size of a table considering all fields,
there used to be a dbsize project, search for it.
g.-
On 9/21/06, Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
Hello all,
I need a tool or something like it, which can give me the estimated size
of a table considering all fields, constraints, indexes, etc...
For example:
CREAT
Thanks everyone, it came back up a few minutes after I sent the SOS.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, September 21, 2006 11:58 AM
To: Mr. Dan
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] psql: FATAL: the data
Hello all,
I need a tool or something like it, which can
give me the estimated size of a table considering all fields, constraints,
indexes, etc...
For example:
CREATE TABLE products (
product_id INT8,
product_name VARCHAR(50),
product_vendor VARCHAR
"Mr. Dan" <[EMAIL PROTECTED]> writes:
> We had to kill postmaster, and it's been ugly. The last backup finished
> successfully not last night, but the night before. This is 161 GB database.
>How long should I expect this to take before it starts.
Not longer than the time since the last ch
Try using the fast shutdown switch with pg_ctl i.e. -mf, that might help.Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com)
On 9/21/06, Mr. Dan <[EMAIL PROTECTED]> wrote:
Hi,We had to kill postmaster, and it's been ugly. The last backup finishedsuccessfully not last night, but the night befo
Hi,
We had to kill postmaster, and it's been ugly. The last backup finished
successfully not last night, but the night before. This is 161 GB database.
How long should I expect this to take before it starts. Developers are
coming into my office every 5 minutes asking for updates. It's
Hello admins,
I have a PostgreSQL 8.1.4 server under Linux Red Hat with several
databases. The server is configured with WAL archiving turned on. As a
maintenance process, every night one cron job launches a backup process
to the server with
pg_dump, then the server shuts down and starts up an
14 matches
Mail list logo
