Обсуждение: tablespaces
Can tablespaces be defined in the postgresql.conf file? In order to encrypt or databases we need a .decru file in $pg_data, this causes the tablespace command to fail. Initdb fails to, but we can work around it.
Has anyone noticed that doing a PITR during DST (March-November) has the effect of being one ahead. Now I just adjust the requested time an hour earlier, but is there a better way?
~DjK
8.4.4
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. Get busy.
Has anyone noticed that doing a PITR during DST (March-November) has the effect of being one ahead. Now I just adjust the requested time an hour earlier, but is there a better way?
~DjK
8.4.4
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. Get busy.
dx k9 <bitsandbytes88@hotmail.com> wrote: > Has anyone noticed that doing a PITR during DST (March-November) > has the effect of being one ahead. Now I just adjust the > requested time an hour earlier, but is there a better way? I haven't noticed any odd behavior with PITR around Daylight Saving Time boundaries. Could you describe exactly how you have it set up and what you're seeing? -Kevin
TIME ZONE is set to unknow in the conf file. The server syncs with NTP, has the correct time, but there is no TMZ env variable set. I set the recovery.conf to an hour before I want it and the logs show the time I wanted during DST. For example if I want a PITR of 9:55 AM, I put in 8:55 AM on the recovery.conf file, then the logs show a restore time of 9:55 AM was requested, and that's what gets processed. The non-DST part of the year, PITR works as expected and no adjustment is necessary.
> Date: Thu, 15 Jul 2010 14:34:11 -0500
> From: Kevin.Grittner@wicourts.gov
> To: bitsandbytes88@hotmail.com; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] tablespaces
>
> dx k9 <bitsandbytes88@hotmail.com> wrote:
>
> > Has anyone noticed that doing a PITR during DST (March-November)
> > has the effect of being one ahead. Now I just adjust the
> > requested time an hour earlier, but is there a better way?
>
> I haven't noticed any odd behavior with PITR around Daylight Saving
> Time boundaries. Could you describe exactly how you have it set up
> and what you're seeing?
>
> -Kevin
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. Get busy.
> Date: Thu, 15 Jul 2010 14:34:11 -0500
> From: Kevin.Grittner@wicourts.gov
> To: bitsandbytes88@hotmail.com; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] tablespaces
>
> dx k9 <bitsandbytes88@hotmail.com> wrote:
>
> > Has anyone noticed that doing a PITR during DST (March-November)
> > has the effect of being one ahead. Now I just adjust the
> > requested time an hour earlier, but is there a better way?
>
> I haven't noticed any odd behavior with PITR around Daylight Saving
> Time boundaries. Could you describe exactly how you have it set up
> and what you're seeing?
>
> -Kevin
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. Get busy.