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 =
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 s
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 w
2010/2/13 sergio barrera
> 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 ter
2010/2/13 sergio barrera
> 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 ter
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 a
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 writes:
> > Hi. What I see when I do ls on the current (corrupt)
> > $PGDATA/global is
> > ...
> > - rw
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 TPC-B-like
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 d
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
e
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 have
On Sat, Feb 13, 2010 at 12:19 AM, Greg Smith 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 the ANALYZE
12 matches
Mail list logo
