Tagged Questions
0
votes
0answers
26 views
Performance of large queries on low bandwidth connections
I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
1
vote
1answer
35 views
Restrict access for Windows administrator in PostgreSQL
Is there a way to protect PostgreSQL from user with Windows administrator rights?
Like this question but for Postgres.
2
votes
2answers
62 views
Changing PostgreSQL port using command line
My PostgreSQL default port is 5432, I want to change default port by using command line (in Windows 7).
I saw this solution before: http://stackoverflow.com/questions/187438/want-to-change-pgsql-port
...
0
votes
0answers
144 views
Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
I had installed PostgreSQL 9.2 earlier and it always installed with the encoding being WIN1252 (the default database was WIN1252). I then some time ago reinstalled it with the encoding being UTF8 (I ...
2
votes
1answer
169 views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
1
vote
1answer
83 views
Determining the full postgresql size on windows
While opening the Programs and Features tool panel on my Windows 7 (64-bit), I found that my postgresql (8.4) install was taking 108 GB.
I do not use postgresql myself, I just use a tool that need a ...
3
votes
2answers
214 views
Problems connecting to Windows-based Postgresql
Other computers are having trouble even finding the running Postgresql 9.1 on my Windows 7 machine. Local connections work just fine of course.
In my pg_hba.conf I have:
#office subnets
host all ...
3
votes
1answer
120 views
pg_dump freezes on windows service application
I have a system running over Tomcat which executes a backup batch job every day, it calls pg_dump.exe from Java and stores its output to an SQL file.
When I'm executing Tomcat from the shell, it ...
1
vote
1answer
309 views
Permission denied in file trying to import
When I try to use \i on a file that is not in the psql.exe folder it says C:: permission denied. For example I have a file with SQL command at C:\Users\Work\Desktop\School Work\load_database.sql and ...
2
votes
1answer
167 views
Logging to a file in PostgreSQL windows service
I need an alternative for running the following command:
C:\xxx\pgsql\bin\pg_ctl" -D "C:\xxx\pgsql\data" -l "C:\yyy\log\pgsql.log" start.
This way the server starts and logs to C:\yyy\log\pgsql.log. ...
0
votes
2answers
363 views
Reloading .sql file from java into PostgreSQL - Windows
I am trying to reload a .sql script file into PostgreSQL from my sample Java application.
Script is successfully executed from console as well as from pgAdmin tool. But from Java, it hangs...
This ...
3
votes
1answer
2k views
Pg install: “The database cluster initialisation failed”
(Note: This question has been compeltely rewritten from its original form, so it reflects the actual problem and will help others find a solution to the same issue).
I still haven't been able to ...
0
votes
0answers
48 views
Long disk queue when no traffic
I got dedicated disk (RAID 10 - 4 SAS disks) for Postgres. I am bit worried as recently, I see under Windows Resource Manager disk queues like 3+ in the mornings (low traffic hours), like every 30-60 ...
0
votes
0answers
143 views
PG_CTL starts postgres.exe but then it exits for some reason [closed]
I start postgresql server from Services menu,
pg_ctl.exe launches,then postgres.exe launches and file postmaster.pid is created in data folder.
Then however postgres.exe exits for some reason (I ...
2
votes
2answers
362 views
How to force Windows to support not supported LC_COLLATE and LC_TYPE in PostgreSQL?
I have fresh installation of PostgreSQL 9.1.x. Unfortunately, I discovered that OS doesn't support LC_COLLATE = 'pl_PL.utf8' and LC_CTYPE = 'pl_PL.utf8'. I read in PostgreSQL documentation that:
...
3
votes
2answers
6k views
How do I reset the postgres password for PostgreSQL on Windows?
I have installed PostgreSQL on my Windows machine for development. Now I haven't used it for a while, and have forgotten the password for user postgres (default admin user in PostgreSQL). How can I ...
2
votes
1answer
7k views
How to import a.csv file into a postgresql database using \copy?
I am trying to import a .csv file into a postgresql database. I am using pgadmin III for that on a win7 machine.
My query looks like that:
\COPY pop_grid(GRID_ID, POP_TOT, YEAR, METHD_CL, CNTR_CODE, ...
2
votes
1answer
349 views
PostgreSQL 9 'pgstats wait timeout' problem
I'm asking about this here because in the PostgreSQL mailing lists no one answered me.
In one of my servers (Windows 2008 R2 Standard/PostgreSQL 9.0.5 64 bits) the logs are being flooded with the ...
1
vote
1answer
351 views
Tutorial for installing and setting up 'streaming replication' with PostgreSQL on Windows XP
Please refer to the diagram in the link below. While looking at my goals.
http://i.stack.imgur.com/GkVWb.png
GOAL:
Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
'on ...
5
votes
2answers
4k views
PostgreSQL: The database cluster initialization failed
Both C:\PostgreSQL and C:\PostgreSQL\data have postgres user with full access and admin rights.
I ran postgresql-9.1.2-1-windows.exe from postgres user as admin. Target C:\PostgreSQL
Every way I ...
1
vote
1answer
1k views
64 bit Postgres 9.1 Limitions on Windows 2008 R2?
When Deploying Postgres on Windows Server 2008 R2:
Are there any limitations on windows that don't exist on Linux?
Does the postgres scale in the same way on windows as it does on Linux?
Is ...
2
votes
1answer
274 views
PostgreSQL archive_command on Windows
What is the best method for WAL log transfer on Windows?
I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit.
Servers do not have any shared SAN disk, they are on different hosts, ...
2
votes
1answer
1k views
How do I install pgcrypto on Windows?
I would like to install pgcrypto in Windows. I have a file C:\Program\PostgreSQL\9.0\share\contrib\pgcrypto.sql but when I try to run it in psql I get an error:
C:: Permission denied
How do I solve ...
2
votes
1answer
617 views
How can I configure PostgreSQL 9.0 to start automatically under Windows XP, Part II?
Two weeks ago I asked "How do I configure Windows XP to start the postgresql demon after each boot/reboot?", and BenV helped me out with his answer:
Make sure the service is set to start ...
1
vote
1answer
2k views
How can I configure PostgreSQL 9.0 to start automatically under Windows XP?
Yesterday I installed PostgreSQL 9.0 on Windows XP, and after the installation the DB was running. After booting the system this morning, the data base server did not start automatically.
How do I ...
