Without worrying about debugging your script, have you considered using
pg_standby that's in contrib? It works well and you don't have to fuss
with scripts unless you're doing something special.
David
---(end of broadcast)---
TIP 9: In versions
2008/2/13, Tena Sakai <[EMAIL PROTECTED]>:
> b) keep the 8.2.4 up and running, but via pg_hab.conf
> make sure nobody can use the database.
That's basically up to you, you can leave it open. The backup will be
consistent, but it won't contain any changes made to the database
after pg_dumpall
I am getting a lot of CONTEXT information along with the message when an
EXCEPTION is raised. Does anyone know what controls whether EXCEPTIONS add
the CONTEXT or not? This problem appeared recently in our server - 8.1.9/linux
- but none as far as we can tell we have not changed the configuration.
Hello Markus,
Fantastic! I have a few more (manual and reference)
pages to read, but I am definitely warming up to the
challenge.
Many thanks for your (and others') reply and thoughts.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Markus Bertheau [mailto:[EMAIL PROTE
Hi,
How can I find out how much space is taken up by database objects in data files?
Thanks
Peter
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Wed, Feb 13, 2008 at 11:27:16AM -0600, Michael Shapiro wrote:
> I am getting a lot of CONTEXT information along with the message when an
> EXCEPTION is raised. Does anyone know what controls whether EXCEPTIONS add
> the CONTEXT or not?
In the server logs the log_error_verbosity configuration se
The $dbh->{errorlevel} is set to 1 (default), which implies the extra
verbosity is some setting in the server, right?
The server log_error_verbosity is set to terse, so the server shouldn't add
the CONTEXT.
I remain baffled by what I am seeing.
On Feb 13, 2008 1:11 PM, Michael Fuhr <[EMAIL PROTE
Hi
Im not sure ;]
but ...
http://www.postgresql.org/docs/8.3/static/functions-admin.html
and table 9-54
merlin=# select tablename, pg_size_pretty(pg_relation_size
(tablename)) from pg_catalog.pg_tables where tableowner='merlin';;
tablename | pg_size_pretty
---+
foo
I tried setting dbh->{pg_errorlevel} = 0 and 2
Neither setting produced the CONTEXT messages. 0 wasn't any different that
1, and 2 added
LOCATION: exec_stmt_raise, pl_exec.c:2113
On Feb 13, 2008 1:11 PM, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Feb 13, 2008 at 11:27:16AM -0600, Michael
Hi,
I've struggled with this one too. You can get the size of databases
with SELECT pg_database_size('database name'); You can get the size
of tables with SELECT pg_relation_size('table name');
Carol
On Feb 13, 2008, at 1:43 PM, Peter Kovacs wrote:
Hi,
How can I find out how much space
"Michael Shapiro" <[EMAIL PROTECTED]> writes:
> The $dbh->{errorlevel} is set to 1 (default), which implies the extra
> verbosity is some setting in the server, right?
> The server log_error_verbosity is set to terse, so the server shouldn't add
> the CONTEXT.
log_error_verbosity just controls wha
On Wed, 13 Feb 2008, Carol Walter wrote:
I've struggled with this one too. You can get the size of databases with
SELECT pg_database_size('database name'); You can get the size of tables
with SELECT pg_relation_size('table name');
Carol
On Feb 13, 2008, at 1:43 PM, Peter Kovacs wrote:
Hi,
A few days ago, we began seeing this error in our logs:
ERROR: could not read block [redacted] of relation [redacted]: Success
I've encountered "could not read block" errors in other databases in
the past, but have never witnessed the "Success" tag at the end. What
does that mean?
The err
Hello
I have a postgres database version 8.1.11, in an Ubuntu Server 6.10.
Some days before, I have a hardware failure in my server, and after recover
the database I get some problems with tables and I had to REINDEX some of
its.
But now, doing any actions in the database server (for example: S
Hi Everybody,
One more 8.3.0 upgrade question.
Assume I ran configure as below:
./configure --prefix /usr/local/pgsql-8.3.0
And a couple of steps later when I run
"gmake install" will it generate a directory
/usr/local/pgsql-8.3.0 on its own? Or must I
do something like:
gmake install --bui
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> A few days ago, we began seeing this error in our logs:
> ERROR: could not read block [redacted] of relation [redacted]: Success
> I've encountered "could not read block" errors in other databases in
> the past, but have never witnessed the "S
On Feb 13, 2008 2:48 PM, Leticia Larrosa <[EMAIL PROTECTED]> wrote:
>
> Hello
>
> I have a postgres database version 8.1.11, in an Ubuntu Server 6.10.
>
> Some days before, I have a hardware failure in my server, and after recover
> the database I get some problems with tables and I had to REINDEX
Thanks, appears to work great!!
Peter
On Feb 13, 2008 9:46 PM, Jeff Frost <[EMAIL PROTECTED]> wrote:
> On Wed, 13 Feb 2008, Carol Walter wrote:
>
> > I've struggled with this one too. You can get the size of databases with
> > SELECT pg_database_size('database name'); You can get the size of tab
Many thanks, Tom!
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wed 2/13/2008 7:32 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] more 8.3.0 upgrade question
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> And a couple
19 matches
Mail list logo
