sathiya psql wrote:
versions 7.4 and 8.3 are stable releases ( am i right ??? )
where can i find the list of differences between these two versions ???
Go here:
http://www.postgresql.org/
On the right, under "Latest releases", there is a notes link for each
major version.
There are 3
"sathiya psql" <[EMAIL PROTECTED]> writes:
> versions 7.4 and 8.3 are stable releases ( am i right ??? )
> where can i find the list of differences between these two versions ???
http://www.postgresql.org/docs/8.3/static/release.html
regards, tom lane
--
Sent via pgsql-a
I copied the system zonefiles into the postgres database and it works
fine now. This is anyway a temporary solution until we upgrade all our
systems.
Thanks to all for your suggestions and help.
Tom Lane wrote:
Shilpa Sudhakar <[EMAIL PROTECTED]> writes:
As i said, we have version 8.2.4
versions 7.4 and 8.3 are stable releases ( am i right ??? )
where can i find the list of differences between these two versions ???
Shilpa Sudhakar <[EMAIL PROTECTED]> writes:
> As i said, we have version 8.2.4 databases and if i need to just update
> the timezone files for this database do i copy the zoneinfo files from
> the OS zonefile or from the newer version of Postgres zonefiles.
If your platform uses the standard zon
Hi Tom,
Thanks. I'll look into upgrading the database. Since we have a huge
bunch of databases i was thinking of an alternative for now.
As i said, we have version 8.2.4 databases and if i need to just update
the timezone files for this database do i copy the zoneinfo files from
the OS zonef
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Shilpa Sudhakar wrote:
>> If DST changes are done in version 8.2.5 and up, is there any way to
>> recompile the timezone files in our existing versions without upgrading.
> FWIW this change is also in 8.1.11.
... and 8.0.14 ...
Anyway, yes, you coul
Shilpa Sudhakar wrote:
> Hi Tom,
>
> If DST changes are done in version 8.2.5 and up, is there any way to
> recompile the timezone files in our existing versions without upgrading.
FWIW this change is also in 8.1.11.
--
Alvaro Herrerahttp://www.CommandPrompt.com
Hi Tom,
I live in Adelaide Australia. I checked in 3 servers and all of them
have "Australia/South" when i ran "show timezone"
For the new timezone files, do i need to apply a timezone patch?
Thanks
Tom Lane wrote:
Shilpa Sudhakar <[EMAIL PROTECTED]> writes:
1) Checked the *postgresql.c
Shilpa Sudhakar wrote:
> Hi Tom,
>
> If DST changes are done in version 8.2.5 and up, is there any way to
> recompile the timezone files in our existing versions without upgrading.
Why would you do that? It's silly. Just upgrade.
--
Alvaro Herrerahttp://www.Co
Shilpa Sudhakar <[EMAIL PROTECTED]> writes:
> 1) Checked the *postgresql.conf file* and the *timezone *parameter is
> set as "*unknown*".
What does SHOW TIMEZONE report? Given the above, Postgres will try to
deduce what zone your operating system is using, but that doesn't always
work perfectly
Hi Tom,
If DST changes are done in version 8.2.5 and up, is there any way to
recompile the timezone files in our existing versions without upgrading.
Thanks
Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Shilpa Sudhakar wrote:
From 2008, the DST ends on first Sunday of A
Hi Alvaro,
Thanks for the info.
I assume Postgresql should have already known about the DST changes in
Australia.
I'll check the mailing list from the link you sent to see if there's
anything regarding this.
Thanks and Regards,
Alvaro Herrera wrote:
Shilpa Sudhakar wrote:
From 2008
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Shilpa Sudhakar wrote:
>> From 2008, the DST ends on first Sunday of April and not on the last Sun
>> of March.
> Please report this issue to the guys maintaining the TZ database
> upstream:
You sure they don't know about it already?
# southeast Aust
Shilpa Sudhakar wrote:
> From 2008, the DST ends on first Sunday of April and not on the last Sun
> of March.
Please report this issue to the guys maintaining the TZ database
upstream:
http://news.gmane.org/gmane.comp.time.tz
Because my country is having a TZ DST change this Saturday, a new
re
On Fri, Mar 07, 2008 at 09:26:51AM +1030, Shilpa Sudhakar wrote:
> Hi Tom,
>
> We have different databases with different versions.
>
> I checked the database with *version 8.2.4* by running the below query
>
> echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL
> \'1 second
Hi Cat,
As per my previous mail, i've done few checks on the postgres timezone
files but not sure if am looking at the right file.
I'll paste the details again below .
1) Checked the *postgresql.conf file* and the *timezone *parameter is
set as "*unknown*".
2)
*/local/pkgsrc/databases/pos
Hi Tom,
We have different databases with different versions.
I checked the database with *version 8.2.4* by running the below query
echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL
\'1 second\'\; | psql template1
?column?
---
2008-03-31 2
> I am trying to re-install PostGresSQL on my computer by uninstalling it
first.
Postgres Version? Windows or Linux?
THINK BEFORE YOU PRINT - Save paper if you don't really need to print this
***Confidentiality and Privilege Notice***
The material contained in
Marc Fromm wrote:
We have a database that we use each year.
Each year the database needs to be free of any data from the past year.
We need to retain last years data base with its data.
I tried using template:
CREATE DATABASE 'year2007-2008' TEMPLATE 'year2006-2007';
But the new database conta
We have a database that we use each year.
Each year the database needs to be free of any data from the past year.
We need to retain last years data base with its data.
I tried using template:
CREATE DATABASE 'year2007-2008' TEMPLATE 'year2006-2007';
But the new database contains all the data from
I am trying to re-install PostGresSQL on my computer by uninstalling it first.
When I try to re-install it and get to the screen that asks me to 'initialize
the database cluster', it won't let me do it, saying that I need to delete the
data directory first.
This is my question, How do I dele
Vishal Arora <[EMAIL PROTECTED]> writes:
> Hi, I've been working on a timezone issue. I am in Adelaide Australia
> and the daylight savings time this year has been changed. I am trying
> to figure out the file which is required to be changed.
The easiest and best solution would be to update to a n
>>> On Thu, Mar 6, 2008 at 10:20 AM, in message
<[EMAIL PROTECTED]>, "Marc Fromm"
<[EMAIL PROTECTED]> wrote:
> And both are the same thing?
According to the documentation, postmaster is a deprecated alias for the
postgres executable.
http://www.postgresql.org/docs/8.2/interactive/app-postma
I am puzzled on the supposed two methods of starting postgres--"pg_ctl
start" and "service postgresql start". Below is my understanding. It
would be great to have some clarification on them.
My confusion stems from when I first intitiated postgres by creating the
database cluster with "initdb". I
25 matches
Mail list logo
