[GENERAL] Postgres does not accept socket connections

2006-03-02 Thread kishore . sainath
Hi All, I have the following problem. I am able to access a PostgreSQL database only as "localhost". If I try to open psql from a different machine with -h option, then I get the following error message. The database resides on a server running Fedora Core 4 and PostgreSQL 8.1.1 server. I am try

[GENERAL] Converting an ASCII database to an UTF-8 database

2006-02-17 Thread kishore . sainath
Hi All, I have a database in PostgreSQL which is ASCII. Due to some internationalization issues, I need to convert the database to the UTF-8 format. So my question is: How do I convert a database in the ASCII format into one of the UTF-8 format? Thanks in advance - Kishore

Re: [GENERAL] A tale of two similar databases

2006-01-19 Thread kishore . sainath
Hi All, I haven't vacuum/analysed the D2 database or for that matter D1. In fact I have never used VACUUM before. Maybe that is the problem. What are the benefits of the VACUUM command in PostgreSQL? Thanks in advance - Kishore ---(end of broadcast)-

[GENERAL] A tale of two similar databases

2006-01-17 Thread kishore . sainath
Hi All, I am using PostgreSQL 7.3.2 on a server running Red Hat Linux 9.0. I have two databases ( identical schema and similar data ). One database, D1 contains the actual data of a Production Application. The other D2 contains dummy data which is used during development and testing of the appli