On Sat, Feb 13, 2010 at 12:19 AM, Greg Smith g...@2ndquadrant.com wrote:
Amitabh Kant wrote:
You need to do VACUUM FULL ANALYZE to claim the disk space, but this
creates a exclusive lock on the tables.
See http://www.postgresql.org/docs/8.3/static/sql-vacuum.html
First off, you don't need
Marc Mamin wrote:
Looking at the TODO List, I feel that only some aspects of the COPY
FROM command are adressed.
Could a discussion trigger some activity on this topic :o) ?
(Sounds only of crickets chirping)...guess not. I would love to have
FEEDBACK added.
The TODO list doesn't
Buenas compañeros!
Tengo un problema al cual no le encuentro la
lógica. Mi idea es realizar una copia de seguridad de una base de datos
PostgresSQL diaria bajo el sistema operativo Linux-Ubuntu 9. Para ello primero,
he ejecutado el siguiente comando en el terminal, obteniendo una respuesta
Greg Smith wrote:
Jeff Ross wrote:
I think I'm doing it right. Here's the whole script. I run it from
another server on the lan.
That looks basically sane--your description was wrong, not your
program, which is always better than the other way around.
Note that everything your script is
Jeff Ross wrote:
Hopefully if I can get it to run well under pgbench the same setup
will work well with drupal. The site I was worried about when I went
to this bigger server has started a little slower than originally
projected so the old server is handling the load.
The standard
Thanks, Tom. I will give this a try and let you know what happens.
I don't see anything in the logfile prior to the first could not read
block 0... error.
Thanks,
Janet
Janet S Jacobsen jsjacob...@lbl.gov writes:
Hi. What I see when I do ls on the current (corrupt)
$PGDATA/global is
Hi,
I need an hosting account with PostgreSQL and PHP. I have signed an account
with HostNine.com, but the PostgreSQL is the 8.1, and don't allow to create
Languages and Triggers, so I can't get the website working...
Please tell me if you know a good hosting with PostgreSQL that allow
Triggers
2010/2/13 sergio barrera xpbarr...@hotmail.com
Buenas compañeros!
Tengo un problema al cual no le encuentro la lógica. Mi idea es realizar
una copia de seguridad de una base de datos PostgresSQL diaria bajo el
sistema operativo Linux-Ubuntu 9. Para ello primero, he ejecutado el
siguiente
2010/2/13 sergio barrera xpbarr...@hotmail.com
Buenas compañeros!
Tengo un problema al cual no le encuentro la lógica. Mi idea es realizar
una copia de seguridad de una base de datos PostgresSQL diaria bajo el
sistema operativo Linux-Ubuntu 9. Para ello primero, he ejecutado el
siguiente
On Wed, 2010-02-10 at 03:46 +, Iain Barnett wrote:
CREATE TYPE inventory_item2 AS (
nametext,
supplier_id integer,
price numeric,
size integer
);
but it would be handy if I could reuse inventory_item instead of
having to retype the whole lot.
Hi. I am trying to restore a database from a pgdump file, something
that I've sucessfully done before.
I created a new database cluster, created the database that I want
to restore using
create database subptf with template = template0;
and then I tried to restore the database using
./psql
On Feb 13, 2010, at 7:36 PM, Janet S Jacobsen wrote:
Hi. I am trying to restore a database from a pgdump file, something
that I've sucessfully done before.
I created a new database cluster, created the database that I want
to restore using
create database subptf with template =
12 matches
Mail list logo