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

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

4. >Are the connections across a network and if so is there a firewall between the >clients and server(s)? No FW involved. All the connections are local. This is a pure , inconsistent Server problem. See BUG #5578: postrgesql database crash .... Thanks Danny -- Sent via pgsql-ge

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

process. Thanks Danny

[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

This is exactly what I am trying to do - To find a CREATE DATABASE statement that will produce a database that has a binary sorting. Thanks Danny -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Monday, December 12, 2011 5:53 PM To: pgsql-general

[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

n tell for sure, reading the release notes that it is fixed for 8.2.18, 8.3.8 and 8.4.1. What about the 9.X ? Thanks a lot Danny

[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?

d_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) not like ''; 21282 | update cmr_lastno set lastisn=lastisn+1 where tablename='DANNY'; 25936 | in trans

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

a? Thanks Danny

[GENERAL] FW: postgres 8.2.4 cores on SUN

a? Thanks Danny

[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/mail

[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:

[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 mai

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

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

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

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

[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

[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

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 encoding explicitly, or choose a matching combination. Thanks Danny Abraham -- Sent via pgsql

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

ed to set the autovacuum parameter value to off but unfortunately it did not help 1. Is this bug defined for the 8.2.4 code line also (We know that it is defined for 8.1.X) 2. How can we recreate the problem? 3. Is there a fix for that bug? Any help will be appreciated. Best regards, Danny Ab

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

me in recreating the problem? Everything runs Fine for me ona US machine, for both LC_MESSAGES="C" as Well as LC_MESSAGES="en_US.ISO8859-1" Thanks a lot Danny Abraham -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] COPY TO duplicates "\" signs

here. Any ideas? Help will be appreciated. Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[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 PR

[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.or

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

tell that the index is being used. Any idea? Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[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

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

taddr=127.0.0.1 .' The following were tried but did not help: 'host=localhost' and even providing the real target server ('host=tlvl0390') did not help. Happens on WIndows as well as Unix Can you help? Thanks Danny ---(end of broadcast)---

[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; ===

[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)---

[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

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

ate_on_rotation = on log_rotation_age = 1d log_rotation_size = 10MB Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

[GENERAL] HD is flooded by Error Log info

ename = 'CTMD-%d.log log_truncate_on_rotation = on log_rotation_age = 1d log_rotation_size = 10MB Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED]

[GENERAL] Streaming LIBPQ? Sliding Window in LIBPQ?

any "SLiding Window" layer that breaks the PGresult into chuncks? Big queries take a lot more memory on the client side compared to other DB clients. Thanks Danny Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED]

[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] ---

[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 broadc

Re: [GENERAL] YTA Time Zone Question

rewrite my function that converts the unix timestamp: SELECT TIMESTAMPtz 'epoch' + INTERVAL '1170728520 seconds'; -Danny -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Friday, April 06, 2007 9:38 AM To: Danny E. Armstrong Cc: pgsql-general@postgr

[GENERAL] YTA Time Zone Question

rpret the value as utc and then not offset it when I view it, like python and ruby do? Any help is appreciated, Danny ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Could not open service manager

service manager" Note I opened a cmd.exe session as postgres user. Can anyone help me out here? regards, Danny __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---

[GENERAL] Best approach setting up PostgreSQL

the databases run in their own cluster. If you are in the same situation how have you handled it? I am running PostgreSQL on Windows XP (native). Can I run multile database servers? Or is it only possible to have one database server with different database locations? regards, Danny

[GENERAL] server not starting

command is not giving any help. Can someone help me out here. I have been looking whether there was a postmaster.pid file residing somewhere but I can not find it. So that will not be the cause for the server not starting. regards, Danny __ Do You

Re: [GENERAL] Postgres under Windows

. regards, Danny --- John DeSoi <[EMAIL PROTECTED]> wrote: > Danny, > > On May 30, 2005, at 10:13 AM, Danny Gaethofs wrote: > > > Now I try to create a database as explained in the > > documentation: > > > > createdb mydb > > > >

Re: [GENERAL] Postgres under Windows

Tony, I tried your suggestion but it is not helping me out. Restarting the server is not helping either. What I tried next is create the database in pgadminiii and assign my userid as the owner. But that is not working either. So I have run out of options. regards, Danny --- Tony Caduto

[GENERAL] Postgres under Windows

But this does not help either. Why am I not able to connect to the database template1? regards, Danny __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[GENERAL] initdb failed

Hi, I just installed Postgresql 7.3.2 with Cygwin on my computer. When I try to run "initdb -D /usr/postgresql/data" I get this message: Signal 12 Signal 12 50 creating configuration files... ok creating template1 database in /usr/data/base/1... Signal 12 initdb: failed can somebody help me out?

[GENERAL] how come I get this error message when I try to connect to Postgresql

Hello all, I am running Postgresql 8.0.0 on Windows 98. When I try to connect to the database with psql.exe using "psql.exe -h localhost -p 5432 template1 postgres" I get an error message like this: PSQL: could not connect to server: Connection refused (0x274D/10061) Is the server r

[GENERAL] How do I connect to Postgresql on Windows 98?

Hello all, I just want to know how I should connect to Postgresql while running Windows 98 (no networking)? Dan _ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01

Re: [GENERAL] Users

If you want users to access your database remotely. Goto www.phpwizard.net or www.phpwizards.net and look for a product call "myPostgresql " (I believe) which iprovides a web based interface for Postgresql And ithe program is Free, no licence ietc etc. On Tue, 26 Sep 2000, Adam Lang wrote: > T

Re: [GENERAL] Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?

-Hello - If you want the default value to be "0" the code for that is default = '0' Like so CREATE TABLE Customer (Customer_ID INT Default = '0', I believe this should work. dannyh [EMAIL PROTECTED] On Mon, 25 Sep 2000, Philip Warner wrote: > At 19:22 24/09/00 -0500, Dominic J. Eidson wrote

Re: [GENERAL] users

Read this tutorial it has got everyting you need to know about psql. Document herewith attached On Sat, 23 Sep 2000, Chris wrote: > Greetings, > > When ever a normal user (anyaccount besides "postgres") tries to > run psql they get the following message: > > Connection to database 'dank'

[GENERAL] data type (datetime)

- Hello - I have looked for a data type which allows me to have (using a cliche example again) FlightDetail_Arrival whcih is like so 21:07:00 18:00 - When I type this in psql it changes my data type from datetime to "timestamp" - It gives me the following about I did a SELECT * FROM table - 21:

[GENERAL] Psql Question

create a test database using the following commands using a very cliche example . This command works on mySQL and should be part of the ANSI SQL standard mydb=# INSERT INTO Customer (Customer_ID,Customer_Name,Customer_Address,Customer_Email) mydb-# VALUES ('1','Danny Ho','99 Se