I know that in Oracle there are 'alter database begin backup' and 'alter
database end backup' commands that allow you to script your hot backups
through a cron job by calling the begin backup command first, then using
disk backup method of choice and then finally call the end backup command.
-
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I did some research on this and generated the following patch. I didn't
> find much in the way of problems except two vacuum.c fields that should
> probably be BlockNumber. freespace.c also has a numPages field in
> FSMRelation that is int. Should tha
Zeugswetter Andreas SB SD wrote:
>
> > OK, so you do a tar backup of a file. While you are doing the tar,
> > certain 8k blocks are being modified in the file. There is no way to
> > know what blocks are modified as you are doing the tar, and in fact you
> > could read partial page writes durin
Thomas Lockhart writes:
> Tatsuo, it seems that we should use SQL99 terminology and commands where
> appropriate. We do not yet implement the SQL99 forms of character
> support, and I'm not sure if our current system is modeled to fit the
> SQL99 framework. Are you suggesting CREATE CONVERSION to
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Christopher Kings-Lynne wrote:
>> I'm thinking that I should put a 'SearchSysCacheCopy' where my @@ comment is
>> to retrieve the attribute by name, and then do a check to see if it's
>> dropped. Is that the best/fastest way of doing things? Seems unfo
...
> So I withdraw my earlier comment. But perhaps the syntax of the proposed
> command could be aligned with the CREATE TRANSLATION command.
Tatsuo, it seems that we should use SQL99 terminology and commands where
appropriate. We do not yet implement the SQL99 forms of character
support, and I
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> BTW, I wonder if we should invent new access privilege for conversion.
I believe the spec just demands USAGE on the underlying function for
the TRANSLATE case, and I don't see why it should be different for
CONVERT. (In principle, if we didn't use a C-o
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> CATALOG(pg_conversion)
> {
> NameDataconname;
> Oid connamespace;
> int4conowner;
> int4conforencoding;
> int4contoencoding;
> Oid conp
Zeugswetter Andreas SB SD wrote:
>
> > As noted, one of the main problems is knowing where to begin
> > in the log. This can be handled by having backup processing
> > update the control file with the first lsn and log file
> > required. At the time of the backup, this information is or
> > can
On Mon, Jul 08, 2002 at 09:59:44PM +0900, Tatsuo Ishii wrote:
> > On Sun, Jul 07, 2002 at 12:58:07PM +0200, Peter Eisentraut wrote:
> > > What would be really cool is if we could somehow reuse the conversion
> > > modules provided by the C library and/or the iconv library. For example,
> >
> No, what I envisioned was a standalone dumper that can produce dump output
> without having a backend at all. If this dumper knows about the various
> binary formats, and knows how to get my data into a form I can then restore
> reliably, I will be satisfied. If it can be easily automated
Hi!
> I've always thought of our release numbering as having "themes". The 6.x
> series took Postgres from interesting but buggy to a solid system, with
> a clear path to additional capabilities. The 7.x series fleshes out SQL
> standards compliance and rationalizes the O-R features, as well as a
> On Sun, Jul 07, 2002 at 12:58:07PM +0200, Peter Eisentraut wrote:
> > What would be really cool is if we could somehow reuse the conversion
> > modules provided by the C library and/or the iconv library. For example,
> ^^^
>
> Very good point.
> As noted, one of the main problems is knowing where to begin
> in the log. This can be handled by having backup processing
> update the control file with the first lsn and log file
> required. At the time of the backup, this information is or
> can be made available. The control file can
> OK, so you do a tar backup of a file. While you are doing the tar,
> certain 8k blocks are being modified in the file. There is no way to
> know what blocks are modified as you are doing the tar, and in fact you
> could read partial page writes during the tar.
No, I think all OS's (Unix and
On Sun, Jul 07, 2002 at 12:58:07PM +0200, Peter Eisentraut wrote:
> What would be really cool is if we could somehow reuse the conversion
> modules provided by the C library and/or the iconv library. For example,
^^^
Very good point. Why use own
Here is a proposal for new pg_conversion system table. Comments?
/*-
*
* pg_conversion.h
*definition of the system "conversion" relation (pg_conversion)
*along with the relation's initial contents.
*
*
> > I am still looking but perhaps you could supress dropped columns from
> > getting into eref in the first place.
>
> OK, that's done. I'm working on not allowing dropped columns in UPDATE
> targets now.
OK, I've fixed it so that dropped columns cannot be targetted in an update
statement, howe
18 matches
Mail list logo
