Postgres and SUN

Re: what is the origin of postgreSQL time

I gues it would work for you:) It works on 8 servers, still not on this 
one. Permissions seem to be set ok too. Where does postgresql store its 
path to timezone directory? Is there any way to see where is it looking 
for timezone file 'Europe/Vilnius' or 'Egypt' (doesnt work too). In fact 
works only abbreviated timezones like MEST, EEST, GMT etc.... This beats 
me. I cant even imagine what to look for further.

-- 
Julius Tuskenis

Tom Lane rašė:
> Julius Tuskenis <julius <at> nsoft.lt> writes:
>   
>> I've noticed that statement SELECT current_timestamp AT TIME ZONE 
>> 'Europe/Vilnius' returns me an error:
>>  ERROR: time zone "Europe/Vilnius" not recognized
>> SQL state: 22023
>> Time zone Europe/Vilnius is the systems timezone. I checked in 
>> pgsql/share/timezone the file is in there. What could be wrong?
>>     
>
>  Maybe there is something wrong with the file
> permissions on the Europe/Vilnius file or one of the containing
> directories?  If the PG server process can't get at that file
> you'd get an error like this.
>
> 			regards, tom lane
>
>   

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Postgres and SUN

On Dienstag, 1. April 2008 Thomas Bräutigam wrote:
> My questions is, is there a recommendation from Postgres about which
> SUN Machine you should choose when you have a huge Postgres Database

This is like you ask "I fly a lot, which airplane should I choose?". 
Please provide exact information. What is "huge", which Sun's do you 
look at. How many transactions per second do you need, how many users, 
what kind of db, ....

Still, even then I don't know if anybody could really help you really. I 
couldn't, as we don't use any Sun's. 

mfg zmi
--

-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

Re: Postgres and SUN

First, please keep the discussion on the mailinglist.

On Dienstag, 1. April 2008 Thomas Bräutigam wrote:
> What is "huge"
> The DB Size is between 500 GB and 2 Terra, mostly over 1 Terra.

Over 1 Tera is kinda huge, I'd say 

> I looked at the Fire V490
> One to three User are necessary
> I don't know the exact transacations per second, but the most of the
> jobs the database have to do is that we have a high amount of
> inserations and deletions in the database.
> What do you mean with what kind of Database?

If it's an offline like application where you just need to store lots of 
information to make some statistics, it wouldn't matter too much if a 
query takes 50 minutes or 60 minutes. If it's like a broker online 
system a single query should optimally take <1ms 

Do you have that db already, and on which hardware. Does it perform 
well? The best is to have a "normal" machine filled with the data to 
see if you need more. It can be surprising how many transactions/s a 
simple AMD dual core with 8GB RAM and a cheap SATA RAID with 16x10krpm 
WD Raptor disks can handle. Probably you can buy such a test machine, 
shouldn't cost more than 3000€, and it's good for a first idea how much 
you need. And if it's too slow, you'll have an estimation of how much 
more power you need. This can save a *lot* of money, as Sun's aren't 
the cheapest iron around, so a smaller model probably saves a lot more 
money than this test machine. 

mfg zmi
--

-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

Re: what is the origin of postgreSQL time

Julius Tuskenis <julius <at> nsoft.lt> writes:
> I gues it would work for you:) It works on 8 servers, still not on this 
> one. Permissions seem to be set ok too. Where does postgresql store its 
> path to timezone directory? Is there any way to see where is it looking 
> for timezone file 'Europe/Vilnius' or 'Egypt' (doesnt work too). In fact 
> works only abbreviated timezones like MEST, EEST, GMT etc.... This beats 
> me. I cant even imagine what to look for further.

Too bad this is 8.1; on something newer, the contents of the
pg_timezone_names view would be informative.

I still suspect an access permissions problem, but the only way I can
think of to be sure is to strace the Postgres backend process while
you issue SET TIMEZONE, and see what filename it tries to open and
what the kernel's return code is.

			regards, tom lane

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Postgres and SUN

Hi Zmi,

Okay thanks for that advice. Sorry its my first day on a mailing list.

But do Postgres have a special recommendation which SUN equipment runs perfect with a Postgres Database?

A time for a query over 30 seconds I would say is to long. So the machine should be fast enough to handle it in
10-20 Seconds. Price for the Machine doesn’t matter at all. The machine should just fit and can handle
this kinda huge database.

Cheers Thomas


-----Original Message-----
From: Michael Monnerie [mailto:michael.monnerie <at> it-management.at] 
Sent: Dienstag, 1. April 2008 14:54
To: Thomas Bräutigam
Cc: pgsql-admin <at> postgresql.org
Subject: Re: [ADMIN] Postgres and SUN

First, please keep the discussion on the mailinglist.

On Dienstag, 1. April 2008 Thomas Bräutigam wrote:
> What is "huge"
> The DB Size is between 500 GB and 2 Terra, mostly over 1 Terra.

Over 1 Tera is kinda huge, I'd say 

> I looked at the Fire V490
> One to three User are necessary
> I don't know the exact transacations per second, but the most of the 
> jobs the database have to do is that we have a high amount of 
> inserations and deletions in the database.
> What do you mean with what kind of Database?

If it's an offline like application where you just need to store lots of information to make some
statistics, it wouldn't matter too much if a query takes 50 minutes or 60 minutes. If it's like a broker
online system a single query should optimally take <1ms 

Do you have that db already, and on which hardware. Does it perform well? The best is to have a "normal"
machine filled with the data to see if you need more. It can be surprising how many transactions/s a simple
AMD dual core with 8GB RAM and a cheap SATA RAID with 16x10krpm WD Raptor disks can handle. Probably you can
buy such a test machine, shouldn't cost more than 3000€, and it's good for a first idea how much you need.
And if it's too slow, you'll have an estimation of how much more power you need. This can save a *lot* of
money, as Sun's aren't the cheapest iron around, so a smaller model probably saves a lot more money than
this test machine. 

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at

// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4


--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

connection problems

Re: connection problems

On Tue, Apr 01, 2008 at 04:44:29PM +0200, Shavonne Marietta Wijesinghe wrote:

> I have my postgresql(ver. 8 ) db on one computer (as localhost) and i'm trying to access it from another
computer but i get the error
> "could not connect to Server: Connection refused"
> 
> I followed the guide and changed the listen_address in the postgresql.conf file 
> listen_addresses='*' 
> 
> and in the pg_hba.conf file I added the IP address of the pc i'm using
> host all all 192.168.X.X/32 trust 
> 
> But i get the same error. What should i do??

Did you restart the postmaster after setting listen_addresses?
Does netstat -tln display the appropiate port listening on *:5432 (or
whatever your port number is)?

Tino.

-- 
„Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi)

www.craniosacralzentrum.de
www.forteego.de

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: connection problems

Re: connection problems

On Tue, Apr 01, 2008 at 05:52:01PM +0200, Shavonne Marietta Wijesinghe wrote:
> Thanks Tino. But what do you mean by "netstat -tln" i use the pgadmin.

So you're on Windows? You didn't mention any operating system...
What does Postgres say on startup?

Tino.

-- 
„Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi)

www.craniosacralzentrum.de
www.forteego.de

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin