Hi,
BKPDIR=/var/postgres/dumps
/usr/local/pgsql/bin/pg_dump -d genx | gzip
> ${BKPFILE}.txt.gz 2>${BKPDIR}/bkp.err
Thanks & RegardsDilipkumar
- Original Message -
From:
Aaron
Bono
To: Mostafizur Rahaman Sohel
Cc: pgsql-admin@postgresql.org
Sent: Monday, July 3
On 7/29/06, Mostafizur Rahaman Sohel <[EMAIL PROTECTED]> wrote:
Hi, Actually I was trying to create backup schedule using postgresql enterprise manager. But failed to do it. Please let me know how I can create backup schedule in postgresql? Regards,
Sohel
Set up a cron job to run pg_dump.
Hi!
Due to a server upgrade (new machine) i ran into the following problem, can
anyone give me a hint?
Since porting the database on the new machine I can't update table columns
containing a multi-line string (ie. containing a line break).
The old system was configured as follows:
Postgres 7.3
Hi, Actually I was trying to create backup schedule using postgresql enterprise manager. But failed to do it. Please let me know how I can create backup schedule in postgresql? Regards, Sohel
Hi All,
I am facing problem while using CVS. I am working on Solaris 10 and
trying to fetch source code of Postgres as " Anonymous CVS" as follows
:
$ cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot
login
(url : http://developer.postgresql.org/docs/postgres/anoncvs.html)
after providing pass
Did you try to reset the statistics ? select pg_stat_reset();
On Thursday 27 July 2006 17:28, Nolan Cafferky wrote:
> Synopsis: VACUUM ANALYZE on full database used to take just a few
> minutes, now it takes several hours, with no apparant improvement in
> successive runs.
>
> Details:
>
> I hav
Thanks Tom - datfrozenxid has been the same for at least the last month on template0 and 1
On 7/31/06, Tom Lane <[EMAIL PROTECTED]> wrote:
adey <[EMAIL PROTECTED]> writes:> select datname, age(datfrozenxid), datfrozenxid, current_date, current_time
> FROM pg_database> If template0 shouldn't be touc
adey <[EMAIL PROTECTED]> writes:
> select datname, age(datfrozenxid), datfrozenxid, current_date, current_time
> FROM pg_database
> If template0 shouldn't be touched (and I don't know of deliberate access to
> it), why is this changing please?
Because current xid is changing and template0's datfr
I have the discussion below in which it is advised that template0 should not be touched, however, my production v8.1.4 template0 and 1 database XID "age", determined with the following query, changes constantly:-
select datname, age(datfrozenxid), datfrozenxid, current_date, current_time FROM p
Thanks so much Andy!
"attach" is a better word.
I was asking how to make PostgreSQL "connect"
to my old folder (fs dir, file system directory).
Or something that would read a folder directly.
psql -V
psql (PostgreSQL) 7.2.2
Yeah, I tried something like what you descibed
before I asked the list f
10 matches
Mail list logo
