October 16th, 2012, 05:50 AM
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.