Thanks Doug. Think hacking the source may be the way to go. I will ask
the Postgres bosses if this the idea is acceptable.
We are only going to store two data items somewhere. One key-timestamp
for each of autovacuum and pgdump
Doug McNaught wrote:
Richard Sydney-Smith <[EMAIL PROTEC
that calls
pgdump/vacuum and records the event is needed to give me peace of mind.
regards
Richard
Doug McNaught wrote:
Richard Sydney-Smith <[EMAIL PROTECTED]> writes:
pch := pchar('pg_dump -C -h '+host+' -U '+usr+' -p '+pswd+ ' -f
&
I presently use the following to export the database and as per my
earleir post hope to have an equivent to do the backup as per:
a) check for time since the last backup
b) if older than hrs
(i) perform a vacuum analyze
(ii) force a call to dbbackup
(iii) add a new record into fsysl
I would like each database to encapsulate its own backup procedure.
Each database contains a table (fsyslog) which has a record of each
backup taken:
At the application level I presently
a) check for time since the last backup
b) if older than hrs
(i) perform a vacuum analyze
(ii)
Thanks Tom. 8.1 has some very tempting features running it on the
windows box ... ayah but I like the lazy days approach of having yum do
the updates so guess the FC4 box will have to await the release of FC5.
r
Tom Lane wrote:
Richard Sydney-Smith <[EMAIL PROTECTED]>
I am running Fedora core 4 with nightly "yum" update. Presently it is
not picking up version 8.1 as an upgrade.
1) If I wait will 8.1 get added to the "yummy" list
or
2) If I add 8.1 via the RPMs will future releases be maintained by "yum"
or do future upgrades have to continue to be done man
Thanks Richard. Backup as compressed worked.
Richard Huxton wrote:
Richard Sydney-Smith wrote:
? In pgAdminIII linked to 8.0.4 server did a backup of all databased.
Chose "plain" and saved to disk.
uninstalled 8.0.4
installed 8.1.0
create database in pgAdminIII v1.4
restore
? In pgAdminIII linked to 8.0.4 server did a backup of all databased.
Chose "plain" and saved to disk.
uninstalled 8.0.4
installed 8.1.0
create database in pgAdminIII v1.4
restore
reports as not a valid archive.
Obviously this is not what I expect.
Some older backups from a 7.4.? server on
Richard Sydney-Smith
Sent: Thursday, November 10, 2005 10:01 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Windows installer fails for 8.1
I have installed successfully on one machine. Removed 8.0 and
then installed 8.1 ok
However the second machine fails.
Asks for the language and then
I have installed successfully on one machine. Removed 8.0 and then
installed 8.1 ok
However the second machine fails.
Asks for the language and then halts.
If I kill process in task manager then installation resumes but then
fails completely with a "Chinese" user name. Computer is laptop with
unsubscribe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Thanks Magnus,
I was specifically trying to avoid the "log into everything" approach.
Figured that if the user has logged into the computer that should be
sufficient to establish their identity.
Magnus Hagander wrote:
Was looking to see if I could get pgAdmin to log into
postgresql
Was looking to see if I could get pgAdmin to log into postgresql 8.0.3
on Windows XP using the current windows login information. Tried using
the ident functionality on pg_hba.conf to no avail.
Can someone post a link to a how to on this subject please?
Also can anyone tell me if there is an
I have a database which over many years and clients has grown to about
140 tables with attendant triggers , rules and views. Having transferred
to the postgresql community from another database provider the design
did not include the use of schema.
During a recent review it struck me just how use
Thanks ,
Would seem there is no problem eith cpanel + postgresql.
thanks for the link to a2hosting I will look them up.
John DeSoi wrote:
On Aug 4, 2005, at 10:28 PM, Richard Sydney-Smith wrote:
I have asked my internet host to include postgresql as part of their
service but it seems
I have asked my internet host to include postgresql as part of their
service but it seems that there are issues in getting it to work with
"cpanel" which is their support service for their clients. Is their a
reason why Postgresql is harder to host than mysql? Is their any docs I
can point the
Thanks. Can see the logic but many users are going to presume that they
can load from "their" desktop. For now I can operate around the issue
but will have to place instructions in big letters unless I want to
answer this adnauseum.
Magnus Hagander wrote:
Windows XP SP2 with Postgresq
Windows XP SP2 with Postgresql 8.0.3
Two commands on fails the other succeeds:
Fails :
select import_sharedata('C:\\Documents and
Settings\\Richard\\Desktop\\EzyChart-20050721');
Succeeds:
select import_sharedata('C:\\EzyChart-20050721');
is it the spaces in the path that postgres does not
I have a application which maintains a number of monthly totals.
recorded, mth1, mth2, mth3 mth12, total
This from the days when I used another DB system to postgresql.
Is there going to be a performance advantage to change to using
postgresql array based datatype for these records? Parti
his site operational again without
having to do a complete database re-install?
thanks muchly
Richard Sydney-Smith
ibisau.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index
20 matches
Mail list logo
