Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-19 Thread Saravanan Nagarajan
sub folder. On 19 September 2013 13:00, Michael Paquier wrote: > On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan > wrote: > > In pglog_txt, > > > > LOG: could not bind IPv6 socket: No error > > HINT: Is another postmaster already running on port 33307? If not,

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-17 Thread Saravanan Nagarajan
. WARNING: could not create listen socket for "localhost" FATAL: could not create any TCP/IP sockets But already, i set ipv6&4 in pg_hba.conf file. My PostgreSQL Version : 9.2.1 -- Saravanan . On 11 September 2013 18:31, Michael Paquier wrote: > On Wed, Sep 11, 2013 at 4:00 AM, Sa

[BUGS] Cant start PostgreSQL Using command prompt

2013-09-11 Thread Saravanan Nagarajan
Hi, I am using PostgreSQL. If am starting the db with System Account/ any domain account using wrapper, the DB is starting fine. If i am trying to start the PostgreSQL DB using command prompt, [Normal mode or Run as administrator.], It wont start. I provided full permission for everyone in Postgr

[BUGS] duplicate key value violates unique constraint "tableName_pk"

2012-11-07 Thread Saravanan Nagarajan
Hi , I am using "Copy From" while dumping bulk data into PGSQL DB from file. While I am trying to insert the rows, if the primary key already exists, the complete transaction terminated. Postgres cannot handle the constraint violations , i found it into http://wiki.postgresql.org/wiki/COPY#Caveat