123 reputation
5
bio website
location
age
visits member for 4 months
seen Apr 21 at 0:09
stats profile views 2

Apr
21
awarded  Teacher
Apr
21
answered trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
Apr
20
revised trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
added 26 characters in body
Apr
20
asked trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
Mar
12
comment Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
@a_horse_with_no_name I am installing postgresql from the executable available on enterpriseDB. The executable installs postgres and also sets up a database cluster with a default database. I guess I could delete the default cluster and then setup a new one but I would like to know how to make it so the installer installs the data cluster as WIN1252 instead of UTF8. It originally installed it as WIN1252 but I somehow switched it to install as UTF8 and would like to switch it back.
Mar
12
comment Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
@a_horse_with_no_name I want to install postgres and have the default database be WIN1252. Currently when I install postgres, the database is UTF8
Mar
12
revised Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
added more info
Mar
12
asked Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
Feb
20
awarded  Student
Feb
20
revised issues with encoding and pg_dump/restore between windows and linux
added 709 characters in body
Feb
20
asked issues with encoding and pg_dump/restore between windows and linux
Feb
20
awarded  Scholar
Feb
20
awarded  Supporter
Feb
20
accepted trying to start a newly created cluster in postgresql on windows
Feb
19
asked trying to start a newly created cluster in postgresql on windows
Jan
29
comment postgresql out-of-memory
yeah sorry, I just read that part. Thanks for your help. I will reduce it and see if that helps.
Jan
29
comment postgresql out-of-memory
I figured 1024 MB would be ok for shared_buffers since that was 1/4 of the total memory. The document said 1/4 of total memory is what you want to shoot for.
Jan
29
comment postgresql out-of-memory
so shared_buffers is the more likely candidate? I was thinking one of the two needed to be reduced, I just did not know which one is the culprit.
Jan
29
comment postgresql out-of-memory
I think around 200 MB
Jan
29
comment postgresql out-of-memory
that I am not sure of. I am getting the error 2 or 3 times throughout the restore