0
votes
1answer
165 views

Postgres 8.4 stopped working

A windows 7 machine running a Postgres 8.4.x server stopped working properly this morning. The errors are more than strange: The service is not running, according to the services control panel. ...
0
votes
1answer
32 views

removing special characters from pg_hba.conf on windows?

I just installed Postgres on Windows 8 as an experiment. I was trying to edit pg_hba.conf, but somewhere along the line, an editor put a couple of "special" characters at the front of the file. Now ...
0
votes
0answers
303 views

Installing PosgreSQL Stack Builder on Windows with a proxy server

I have downloaded and installed PostgreSQL 9.3 (64 bit) on a developer machine running Windows 8.1 (64 bit). This developer machine requires use of a proxy server for accessing hosts external to the ...
0
votes
1answer
182 views

A virtual ftp-server for Windows like ProFTPD [closed]

Is there any solution for Windows which allows creating virtual ftp-server with the user's storage in a MySQL or a PostgreSQL database? Something like ProFTPD for Unix. Thanks for any advice and ...
1
vote
1answer
44 views

postgres 8.4 /Win7 64

I have a database on a hard drive from a computer whose motherboard died. The HD is fine. I'm trying to XCOPY the data directory and overwrite the contents of a Postgres 8.4 data directory on ...
-2
votes
1answer
65 views

how to configure server odbc for postgresql windows [closed]

i want to put in the server machine the database postgresql and i have also to define the client can you tell me how i'm going to configure odbc data source to connect os:windows thanks for your ...
1
vote
1answer
40 views

How make localized messages display correcty?

I am using default PostgreSQL install on Windows XP. Unfortunately localized (non-english) messages are not displayed correctly neither in SQL Shell nor in diagnostic messages during app run-time. ...
1
vote
2answers
729 views

Advice on using postgresql temp_tablespace

I have been running a query that (I assume) generates a large amount of temporary information, as I receive the following error: ERROR: could not write block 16451641 of temporary file: No space ...
1
vote
1answer
2k views

How to restore a file system level copy of a PostgreSQL database (not dump) to a different PC

I am new to PostgreSQL. I have to recover a database which was running in widows XP machine. I have the zip folder of postgres. I have extracted postgres installation in a different PC and started a ...
0
votes
2answers
1k views

Problems with installing a postgres server on a windows machine

I have tried to install a postgres on my windows Vista, but I cannot seem to get it to work. I download PGAdmin tools and when i try to connect to localhost it tells me the generic thing that the ...
0
votes
1answer
97 views

How can I securely set up an available PostgreSQL connection in Windows?

I'm running PostgreSQL in Windows. I have a vanilla installation with a single admin Windows user account, which I've used to install PostgreSQL and pgAdmin III. Using pgAdmin III I created a database ...
2
votes
2answers
139 views

Is it possible to share a PostgreSQL database between Windows and Linux?

Is it possible to use a PostrgeSQL database in Windows and use the same one in Linux after rebooting? Will pointing the data folder to a common folder be sufficient? I know I could test it and then ...
1
vote
1answer
2k views

Unable to start postgres server

This happened after i modified the pg_hba.conf file. It is currently set on trust but the server still asks for a password (even tho when clicking properties the password field is disabled ) . I ...
3
votes
2answers
2k views

Error1053 trying to start postgres as service on windows

I installed postgres on windows7 and tried to start the service through control panel. It produces error 1053. When I try to run postgres.exe from command line, I get this message: C:\Program Files ...
2
votes
3answers
1k views

PostgreSQL server install - can't find or access dll

When i try to install postgresql-9.0.4-1-windows.exe, somewhere at the end of the installation i get an error. "... libintl-8.dll was not found ..." (same as in this thread: ...
0
votes
3answers
750 views

Change data path for PostgreSQL

I run PostgreSQL as a Service. In Administration - Services, I can see the following path "C:\Program Files\PostgreSQL\8.4.3-3.1C\bin\pg_ctl.exe" runservice -w -N "pgsql-8.4.3-3.1C" -D "C:\Program ...
0
votes
2answers
2k views

PostgreSQL won't start anymore

Today, my PostgreSQL doesn't start anymore on my windows machine... I've tried to start the service in windows services and got the following error: Windows could not start the PostgreSQL Database ...
4
votes
3answers
945 views

Why does pg_restore take so much longer on Ubuntu than Windows?

I generated a dump file of 21 MB or so: pg_dump --format=tar --verbose --file=database.backup mydatabase When I import this file on windows doing: pg_restore --dbname mydatabase --verbose ...
1
vote
1answer
777 views

Postgres pgpass windows - not working

DB: Postgres 9.0 Client: Windows 7 Server Windows 2008, 64bit I'm trying to connect remotely to a postgres instance for purposes of performing a pg_dump to my local machine. Everything works from my ...
1
vote
2answers
234 views

How do I automatically connect my client to an ODBC data source on another machine with dynamic IP?

At the customer's place, we've got a postgres DB on a server, and a few clients. We connect them through ODBC-drivers, and all machines run windows (usually XP). Now we had a few annoying issues: ...
0
votes
3answers
2k views

postgres - sharing same pg_hba.conf between IPV4 system and IPV6 system

I am trying to package postgres from one machine to another. The source is windows 7 with IP V6 and target is windows XP with IPv4. Starting postgres on windows XP gives error 2010-11-01 12:01:07 ...
1
vote
1answer
132 views

How to make schema dumps comparable between Windows and Linux

I have two systems running, one on linux and the other on windows. From the linux box, I ran pg_dump against both systems and dumped the schema. pg_dump command: pg_dump -h HOST -U USER -s -f ...
0
votes
1answer
243 views

Is coLinux much slower than native Windows?

If I installed Postgres on coLinux, would it be as fast as installing Postgres natively on Windows? How much of a difference in the coLinux instance would there be if the data were stored in a ...
0
votes
5answers
477 views

how to speed up a database - hardware only

simple question - what is the best way to improve a database's performance using hardware only? in this situation a few very very large tables are being queried very regularly by 1-4 processes at a ...
-1
votes
4answers
620 views

postgresql login from remote

I want to give remote access to my postresql db (8.2) to computers that are at the same lan, at the default config I have added this line to pg_hba.conf where xxx.xx.xx.xx is the ip of the machine ...
1
vote
1answer
169 views

How to make psql completion with Windows?

There is a completion function by the psql command of Cygwin or UNIX There is not the function in psql for a Windows native. How to make psql completion with Windows? may be need readline!?