At 22:42 18/11/2003 -0500, CLIFFORD ILKAY wrote:
Hi,
I am trying to create a PL/PGSQL stored proc in PostgreSQL 7.3.2 on
Mandrake 9.1. I keep getting a "cursor already in use" error even though I
only open the cursor once, fetch using that cursor, and then close the
cursor when I am finished wi
I'm using the command vaccumdb like this:
su - postgres -c "vacuumdb AgenteSIP"
I don't need to introduce the password for postgres.
I think thos is all you need.
Raquel Vieira
On Monday 17 November 2003 10:53 am, Cris Carampa wrote:
> Sorry if this is a naive question. I'm using postgresql
Hi,
I am
trying to replicate a PostgreSQL database with rsync.
Does
anyone have a experience with that?
We wanted
to transfer a database to another machine with the minimum amount of downtime.
We used rsync to make a copy of the database while PostgreSQL was running. this
ofcour
Hi,
I'am trying to create a demo cd (knoppix) with a jdbc application.
This application uses a static (read-only, no insert, modify or delete) 200MB
postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in ramdisk.
postmaster fails to start because can't open the files in these two
Title: RES: [ADMIN] using vacuumdb in crontab
You can alter yuor pg_hba.conf to permit "trust" local connections instead of "md5". This authentication you can left to external connetions. Thi way a think you will execute de vacummdb successfully.
-Mensagem original-
De: R
http://www.varlena.com/varlena/GeneralBits/42.php
Regards
Inaki
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de [EMAIL PROTECTED]
Enviado el: miércoles, 19 de noviembre de 2003 11:33
Para: [EMAIL PROTECTED]
Asunto: [ADMIN] Postgresql DB on a live cd
Hi,
I'
> http://www.varlena.com/varlena/GeneralBits/42.php
> Regards
> Inaki
Thank you Inaki for the direction,
This is the interesting part :
--> log file -- this can be directed to /dev/null
--> There are ways to stop the writing to the log file and pgstat.stat, but pg_clog
cannot be turned off.
Why not have a static copy of the pg_clog on boot, copy it to a ramdisk
and point Postgres there?
Greg
[EMAIL PROTECTED] wrote:
http://www.varlena.com/varlena/GeneralBits/42.php
Regards
Inaki
Thank you Inaki for the direction,
This is the interesting part :
--> log file -- this can be directe
Alle 16:13, mercoledì 19 novembre 2003, hai scritto:
> Why not have a static copy of the pg_clog on boot, copy it to a ramdisk
> and point Postgres there?
>
> Greg
Hi, Greg
My problem is around base (70MB) and pg_xlog (115MB) dirs, and not pc_clog (20Kb) dir
that, as you also say, can be copied t
Hi folks,
I've been asked this question, and it's about a part of PostgreSQL that I've
not looked at.
Is it possible to recover a database from a dump + some form of transaction
log, i.e. if I pg_dump on a nightly basis, and then at noon the database
crashes, can I take the last dump and roll
Hi,
I'am trying to create a demo cd (knoppix) with a jdbc application.
This application uses a static (read-only, no insert, modify or delete) 200MB
postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in ramdisk.
postmaster fails to start because can't open the files in these two
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there!
I've just compiled PostgreSQL 7.4 and come across this problem:
I have a table like this:
CREATE TABLE test (field1 integer, field2 integer default 0);
Then I want to insert some "empty" record like this:
INSERT INTO test (field1, field
On Wed, Nov 19, 2003 at 11:00:25 +0100,
Tomasz Spyrczak <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Then I want to insert some "empty" record like this:
>
> INSERT INTO test (field1, field2) VALUES ('', '');
>
> My question is: how to "convince" PostgreS
On Wed, 19 Nov 2003, Lucio wrote:
> Hi,
>
> I'am trying to create a demo cd (knoppix) with a jdbc application.
>
> This application uses a static (read-only, no insert, modify or delete) 200MB
> postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in ramdisk.
>
> postmaster fails to
> Create a memory file system and mount that onto as the directory its
> trying to use?
Hi Marc
This is what Knoppix already makes: during boot creates /var/lib/pgsql as a link
to a ramdisk (maybe do you mean something different with "memory fs" ?)
Just now with pg_resetxlog (thanks god there's
On Wed, 19 Nov 2003, Tomasz Spyrczak wrote:
> I've just compiled PostgreSQL 7.4 and come across this problem:
>
> I have a table like this:
>
> CREATE TABLE test (field1 integer, field2 integer default 0);
>
> Then I want to insert some "empty" record like this:
>
> INSERT INTO test (field1, field
Hi all,
Just another question on all this :
When will postgres have win32 native
support. I've been gathering information
from bits and pieces I found on the net,
but never got an official answer.
Some said it will be in 7.4, but it's not there,
and from what I gathered about a month ago
was th
It is planned for the next release, which will probably be 7.5, but
might possibly be 8.0. Of course, it was planned for the 7.4 release as
well, but it was not finished in time, so there are no guarantees.
That's about as definitive as it gets (unless you are going to write the
code yourself)
Ro
Stef wrote:
-- Start of PGP signed section.
> Hi all,
>
> Just another question on all this :
> When will postgres have win32 native
> support. I've been gathering information
> from bits and pieces I found on the net,
> but never got an official answer.
We are hoping for 7.5.
> Some said it w
19 matches
Mail list logo
