g the archived WAL
files into the xlog dir and creating a recovery.conf file?
Cheers,
Mike C.
es: http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html
Could someone please clarify for me: Will I lose the INSERT statements performed while a CREATE INDEX is running?
Regards,
Mike C.
On 12/22/05, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:> All the documentation I've seen for PITR points to having to do a file> system copy of sorts.Yes. There's no other way, but why would you want another way?
Mainly because
On 12/23/05, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote:> On 12/22/05, Simon Riggs <[EMAIL PROTECTED]> wrote:> On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:
> > All the documentation I've seen for PITR poin
Hi,I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah; create table blah (start_date timestamp, number_of_days integer);
insert into blah values (current_timestamp, 25);select start_date + number_of_days fro
That works great, thank you!MikeOn 9/11/06, Aaron Bono <[EMAIL PROTECTED]> wrote:
On 9/10/06, Mike C <[EMAIL PROTECTED]
> wrote:
Hi,I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah;
Hi,
I have a corrupt database. I copied the database directory offsite and
restored from a backup. I'm now trying to recover data in the corrupt
database added since the last backup. Any advice on how to approach
this?
It looks like my SAN raid controllers failed (both of them) after
putting in n
On 10/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Mike C" <[EMAIL PROTECTED]> writes:
> > I have a corrupt database. I copied the database directory offsite and
> > restored from a backup. I'm now trying to recover data in the corrupt
> > database a
