Hi, I dont have much experience with Postgres and am mainly an oracle/mysql dba. I am given a new server to install postgres and maintain an existing server that has postgres database and an application running.
I installed postgres from rpms and created databases on the new server. Applications is connected and it seems to be working fine.

I can see the differences between 2 servers in the tables data. Same data is displayed differently. As far as I am aware, the exisitng server was also created by using the same RPMs (We have these in svn).

Hopefully it should be a simple nls configuration between the 2. Can somebody please point me, where to look and how to investigate?

Can somebody also point me, a good read for postgres as well?

Any help, greatly appreciated.

Many thanks