PDA

View Full Version : Postgres problem during installation



Caravaggio_87
08-04-2011, 05:53 AM
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
plpgsql test failed ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
3
testclient return status: 3
testclient return from file: 3
==================== finished PsqlTestClient

Ty very much.

Sarek
08-04-2011, 12:46 PM
Try to download separate Postgre installer here
Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows)
and install it
You can take 9.0 version (32 or 64 bit) - according to your Windows

Patvs
08-04-2011, 10:05 PM
Also make sure the secondary logon is running.
The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

If 8.4/9.0 won't install, use PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)