Re: [GENERAL] PG 924, Windows 2012, error code 487

Hi, Does anyone know whether this link has an open bug? Maybe a fix? http://www.postgresql.org/message-id/5046caeb.4010...@grammatech.com Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpr

Re: [GENERAL] PG 924, Windows 2012, error code 487

Hi, Thanks a lot for your reply ... >From what I can find WSACancelBlockingCall is a Winsock function has to do >with networking/messaging and not memory issues per se. So what makes you >think it is a memory issue >or are the memory problems a separate issue? See below for more detail on WSA

Re: [GENERAL] PG 924, Windows 2012, error code 487

Hi, >Are the servers on the Windows versions you mention or the clients or both? Both clients as well as server are located on the same Windows Server machine. >Where is this error showing up, the Windows or Postgres logs? Both. It appears in the pg_log as well as failing the client >What doe

[GENERAL] PG 924, Windows 2012, error code 487

Hi, Since moving to PG 9.2.4 we are facing many connection refusals from PG Mainly on Windows 8, Server 2012 and Server2012R2. Error ... could not fork new process for connection: A blocking operation was interrupted by a call to WSACancelBlockingCall Sometimes it even fails the AUTOVACUM proc

[GENERAL] Query fluctuates .... Strange strange .....

PG 8.3.7 on HP 11.31. Very strong Server with lots of memory. A query runs that inserts 40K records takes 1 second when run from psql. It takes 20 minutes!! And 100% CPU !! when called from a standalone JDBC program. No other users are running !!! The problematic query: 2013-01-02 15:00:3

[GENERAL] FATAL : could not read directory base": Invalid argument

FATAL : could not read directory base": Invalid argument 8.2.4 on Windows. Service will not start. Any idea -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] sort order

Thanks a lot. Worked fine with . CREATE DATABASE danny Template template0 LC_CTYPE = 'C' LC_COLLATE = 'C'; -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, December 12, 2011 6:07 PM To: Abraham, Danny Cc: Adrian Klaver; pgsql-ge

Re: [GENERAL] sort order

@postgresql.org Cc: Abraham, Danny Subject: Re: [GENERAL] sort order On Sunday, December 11, 2011 8:17:41 am Abraham, Danny wrote: > On PG 9.0.4, Windows, Encoding and Collate WIN1252 trying to get a > database to sort according to the ascii order. Example: > Select t from test order by t &g

[GENERAL] initdb locale WIN1252

What's wrong with locale WIN1252 ? Running successfully initdb, but strange warnings show ... The files belonging to this database system will be owned by user "EMPG". This user must also own the server process. The database cluster will be initialized with locale English_United States.1252. Th

[GENERAL] sort order

On PG 9.0.4, Windows, Encoding and Collate WIN1252 trying to get a database to sort according to the ascii order. Example: Select t from test order by t Should be exactly like Select t from test order by ascii(t). Can it be done? How? Thanks Danny

[GENERAL] Is 9.1 considered more stable/robust than 9.0.4 ?

Thanks Danny

Re: [GENERAL] Identify release contents

Thanks Craig Yes, I am trying to get to a full confidence level. How can I tell which version was 9.0 branched off? Any git 101 document? From: Abraham, Danny Sent: Tuesday, July 19, 2011 1:49 PM To: pgsql-general@postgresql.org Cc: Abraham, Danny Subject: Identify release contents Hi, We

[GENERAL] Identify release contents

Hi, We are on 8.3.7 and interested on upgrading to the 9.0.4. How can I verify that the bug below is fixed for 9.0.4? ( Fix Windows shared-memory allocation code (Tsutomu Yamada, Magnus) This bug led to the often-reported "could not reattach to shared memory" error message.) I can tell for sure

[GENERAL] How do I elimitae ANY loggin to Windows Eventlog? 8.2.4.

Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abra...@bmc.com

[GENERAL] PG 8.3.7. Windows 7. select inet_server_addr() returns ::1 - the loopback adrs.

The machine is on IPV4. How can I retrieve the real IP adrs? Is 8.3.7 supported on Windows 7? Thanks a lot Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abra...@bmc.com

[GENERAL] Who is locking me?

Hi, A process hangs forever. When using this query... SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s where pg_stat_get_backend_activity(s.backendid) n

Re: [GENERAL] Log full of: statement_timeout out of the valid range.

ctrlm700=> show statement_timeout; statement_timeout --- 1h (1 row)

[GENERAL] Log full of: statement_timeout out of the valid range.

Our setup is a real valid one. Looks like it has to do more with remote connections. Any idea? Thanks Danny

[GENERAL] postgres 8.2.4 cores on SUN

Hi, "postgres" cores on SUN 2.9. Disk is in 100% IO. (dbx) where [1] 0x65eacdd4(0x7fffa36c, 0x400, 0x10032d4e8, 0x1, 0x48, 0xd6), at 0x65eacdd4 [2] XLogFileInit(0x48, 0xd6, 0x7fffa85d, 0x1, 0x488000, 0x0), at 0x10007955c [3] XLogWrite(0x48, 0x6, 0x1, 0x1004

[GENERAL] FW: postgres 8.2.4 cores on SUN

Hi, "postgres" cores on SUN 2.9. Disk is in 100% IO. (dbx) where [1] 0x65eacdd4(0x7fffa36c, 0x400, 0x10032d4e8, 0x1, 0x48, 0xd6), at 0x65eacdd4 [2] XLogFileInit(0x48, 0xd6, 0x7fffa85d, 0x1, 0x488000, 0x0), at 0x10007955c [3] XLogWrite(0x48, 0x6, 0x1, 0x1004

[GENERAL] Re: PL/PG SQL: select count(*) into from where - does not compute the where cond - returns always total count

Any idea? Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Re: PL/PG SQL: select count(*) into from where - does not compute the where cond

... forgot the most import issue The problem shows when the selection is from a view. The where condition does not have names contention. It is: select count(*) into from where -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] PL/PG SQL: select count(*) into from where - does not compute the where cond

Instead it returns the full count of the table. Any idea? Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abra...@bmc.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

[GENERAL] Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487

Does anybody have a proven way to regenerate this problem? This way I can decide that the patch does fix it? Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487

Does anybody have a proven way to regenerate this problem? SO that I can tell that the patch really does fix it? Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Re: InitDB 8.3.7 fails on Windows - Failed system call was MapViewOfFileEx

Adding memory and releasing several memory consumers did the trick. Thanks a lot. Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abra...@bmc.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

[GENERAL] PG fails on Windows Server 2008: could not reattach to shared memory ... : 487

The server intermittently fails on simple queries. Log full of the above error log. Does anyone know on which version this problem is fixed? Or a specific patch? Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abra...@bmc.com -- Sent via pgsql-general mailing lis

[GENERAL] InitDB 8.3.7 fails on Windows - Failed system call was MapViewOfFileEx

Hi, InitDB of 8.3.7 fails. Windows XP. Compiled with VC2008, SP1 creating template1 database in ... 2009-08-04 11:46:53.954 GMTFATAL: could not create shared memory segment: 8 2009-08-04 11:46:53.970 GMTDETAIL: Failed system call was MapViewOfFileEx. child process exited with exit code 1 A

Re: [GENERAL] initdb fails on Windows with encoding=LATIN1

We do need LATIN1. The error message is: initdb: encoding mismatch The encoding you selected (LATIN1) and the encoding that the selected locale uses (WIN1252) do not match. This would lead to misbehavior in various character string processing functions. Rerun initdb and either do not specify an

[GENERAL] initdb fails on Windows with encoding=LATIN1

It runs fine with WIN1252. The error message says something about lc_type. Tried with various code pages: 850,1252. Nothing goes through. Any thoughts? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [GENERAL] initdb --encoding=LATIN1 fails on Windows

Thanks. I guess my question is then, how should I configure Windows to have the right locale so that I can create a LATIN1 encoding cluster. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-genera

[GENERAL] initdb --encoding=LATIN1 fails on Windows

The same command worked fine on PG 8.2.4. Now, using 8.3.7, we are forced into WIN1252. Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] initdb --locale=LATIN1 fails on Windows

Actually the command is:initdb --encoding=LATIN1. It fails on Windos. fails on Windows The same command worked fine on PG 8.2.4. Now, using 8.3.7, the command succeeds only with encoding 1252. It comments something on wrong lc_ctype. Thanks Danny -- Sent via pgsql-general mailing list (p

Re: [GENERAL] initdb --locale=LATIN1 fails on Windows

Do you by chance know what is the ISO88591 locale to be used on Windows? It should be something like Americam_United States.ISO88591. Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] initdb --locale=LATIN1 fails on Windows

The same command worked fine on PG 8.2.4. Now, using 8.3.7, the command succeeds only with locale 1252. It comments something on wrong lc_ctype. Any idea? Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgr

[GENERAL] How do I add text to a thread?

I am not " .2 instance that won't come up after shutdown" But cannot add more posts. Thanks a lot Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PG 8.3.7 initdb -E LATIN1 fails on Windows

Hi, Runnning: initdb -E LATIN1 -D . Error: encoding mismatch Used to run fine on 8.2.4 on the same Windows platform. OUTPUT === The database cluster will be initialized with locale English_United States.1252. initdb: encoding mismatch The encoding you selected (LATIN1) and the enc

[GENERAL] 8.2 instance that won't come up after shutdown

Hi We have a PG version 8.2 instance that won't come up after shutdown. The log shows the following: 2009-06-12 21:39:02.669 MDTLOG: database system was shut down at 2009-06-12 20:56:51 MDT 2009-06-12 21:39:02.748 MDTLOG: checkpoint record is at 9/D712F330 2009-06-12 21:39:02.748 MDTLOG: r

[GENERAL] invalid value for parameter "lc_messages": "en_US.ISO8859-1"

Hi, Details below: Initdb fails on: creating template1 database in /ema640/pgsql/data/base/1 ... FATAL: invalid value for parameter "lc_messages": "en_US.ISO8859-1" PG 8.2.4, AIX 5.3 German customer (I assume that it has some implications of locale). Can anyone help me in recreating the pro

[GENERAL] COPY TO duplicates "\" signs

Hi, String in DB: D:\Program Files\BMC Software\CONTROL-D\wa/reports In the output files "\| are duplicated: The string in the output text fileis D:\\Program Files\\BMC Software\\CONTROL-D\\wa/reports == ==== == Standard_conforming_strings will not help here.

[GENERAL] Can anyone explain?

set standard_conforming_strings=on; select 'abcd\efg' like 'abcd\efg' ==> F (I expected it to be T) select 'abcd\efg' like 'abcd\\efg' ==> T (I expected it to be F) Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] -- Sent via pgsql-general mailing list

[GENERAL] Copy fails

I am loading a huge file using C, STDIN The program fails immediately on "canceling statement due to statement timeout" Any idea? Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] Can postgres handle "group by" queries?

Hi, The following query SELECT START_DATE_IDX, COUNT(*) FROM RUNINFO_HISTORY WHERE START_DATE_IDX>=1005 group by START_DATE_IDX runs for about 200s on Postgres, but 13s on MS SQL Server, on the same machine. The searched column is indexed. By reading the "explain" you can tell that the ind

[GENERAL] pg_ctl start fails on Windows

The error message is "could not open PID file". I can manually create the file "postmaster.pid", so the problem Does not look like a permission problem. Thanks Danny ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

[GENERAL] dblink does not connect when activated in a remote server

dblink problem: I am connecting to a remote server and run a functions that calls another one using db_link. It fails with the error message is 08001 - could not establish connection. When the function is located in a local server - it runs fine. The connection string is: 'hostaddr=127.0.0.1

[GENERAL] Instaltiating an ARRAY within a function

=== CREATE OR REPLACE FUNCTION arr( inout x varchar[] ) AS $Z$ DECLARE i integer; BEGIN select ARRAY['Danny','Eissam','Moshe'] into x; end; $Z$ LANGUAGE 'plpgsql' VOLATILE; === CREATE OR REPLACE FUNCTION callarr()

[GENERAL] LIBPQ Exception

How do I program a DML statement that does not roll back using C. res=PQexec(conn,"BEGIN; insert into x values(100); exception when others then null; end;") fails on syntax. Any other alternative? Thanks Danny ---(end of broadcast)--- TIP 9: I

[GENERAL] Question in dblink

I would like the code below to accept the returned value from t2. How do I do it? Thanks Danny === err := dblink_connect('C',cname); begin execute dblink('C','SELECT t2()'); exception when others then null; end; err :=

Re: [GENERAL] HD is flooded by Error Log info

Hello Recently an application endless loop crashed the PG server. I am looking for the safest way  to limit the growth of the all the files in the “pg_log” directory, While still  maintain reasonable period of log. Any suggestions? Our current setup is: #--

[GENERAL] HD is flooded by Error Log info

Hello Recently an application endless loop crashed the PG server. I am looking for the safest way to limit the growth of the all the files in the "pg_log" directory, While still maintain reasonable period of log. Any suggestions? Our current setup is: #--

[GENERAL] Streaming LIBPQ? Sliding Window in LIBPQ?

Is there a way to break the PGresult array to chuncks Like Oracle? I mean, without changing the text of given queries, can we somehow limit the memory consumption of a client that is using LIBPQ? The API is ... extern PGresult *PQexec(PGconn *conn, const char *query); Is there

[GENERAL] LIBPQ: Can we have buffered PGresult (i.e. a retreival by chuncks?)

I am referring to client side computing - no SQL changes can be applied. Is there a LIBPQ dll extension that supports sliding windows like management Of the *PGresult array? Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] ---(end

[GENERAL] LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)

Is there a way to break the PGresult array to chunks Like Oracle? Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Chunk Delete

Say we have a FIFO of 800,000,000 records. No primary key is required - this is only audit information. We do not use it on Oracle too. Based on a condition, 2,000,000 records should be deleted daily. We have a background process that wakes up every X minutes and deletes Y records.

Re: [GENERAL] Chunk Delete

The temporary sequence works perfectly for me. Thanks ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Chunk Delete

THE problem is that the table does not have a primary key; Too expensive.

[GENERAL] Chunk Delete

Say we have a FIFO of 800,000,000 records. No primary key is required - this is only audit information. We do not use it on Oracle too. Based on a condition, 2,000,000 records should be deleted daily. We have a background process that wakes up every X minutes and deletes Y records.

[GENERAL] Chunk Delete

Hi, I am wondering if I can do in PG Chunck Delete, like the Oracle example below. In Oracle we erase 50,000 records using the following: Delete where and ROWNUM < 5; Do we have such a feature in PG? Thanks Danny ---(end of broadcast)-