CODEWITHSUNDEEP
postgresqlantcmd
Loolooii
Loolooii

Reputation: 9162

I get the following error message while I run the command ant CreateDb in cmd:

FATAL: password authentication failed for user "postgres"

I use windows 7, in order to fix the problem, I modified the file pg_hba.cong from 

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

to the following:

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

then I use the same command but this time i get this error:

ERROR: language "plpgsql" already exists.

would someone please explain to me what the heck is wrong??

Upvotes: 0

Views: 2745

Answers (2)

TimP
TimP

Reputation: 965

DROP EXTENSION plpgsql;

psql version 9.1.7

Upvotes: 1

Eelke
Eelke

Reputation: 21993

The error about the language plpgsql occurs because your script is trying to create the language but it is already available in the database. Either you should modify the script so it doesn't try to create the language, look for CREATE LANGUAGE or you could remove the language before hand from your database using DROP LANGUAGE plpgsql;

Upvotes: 2

Related Questions