Re: [GENERAL] PostgreSQL server does not notice that clients have disappeared

2015-01-23 Thread Al Eridani
Thank you for the confirmation! On Fri, Jan 23, 2015 at 1:24 PM, Maciek Sakrejda wrote: > On Fri, Jan 23, 2015 at 12:08 PM, Al Eridani wrote: > >> Is this still true on the 9.x versions? Thanks! >> > > It is, unfortunately. If your client kicks off a 12h query and imme

[GENERAL] PostgreSQL server does not notice that clients have disappeared

2015-01-23 Thread Al Eridani
More than five years ago Tom Lane wrote "It's not easy to tell whether a client has disconnected (particularly if the network stack is unhelpful, which is depressingly often true). Postgres will cancel a query if it gets told that the connection's been dropped, but it will only discover this when

Re: [GENERAL] Building with MinGW issue

2013-09-28 Thread Muhammad Bashir Al-Noimi
Postgresql guys doesn't care about open source compilers like other projects; they're part of open source community why they support commercial compilers and drop the open source!!! -- Best Regards, Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Building with MinGW issue

2013-09-28 Thread Muhammad Bashir Al-Noimi
st Regards, Muhammad Bashir Al-Noimi -- 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] Building with MinGW issue

2013-09-27 Thread Muhammad Bashir Al-Noimi
On 09/27/2013 04:16 PM, Adrian Klaver wrote: I was talking about these: http://www.postgresql.org/download/windows/ Not sure what they are compiled with, it should not matter though. Oh man these binaries built by MSVC which takes us to first square! -- Best Regards, Muhammad Bashir Al

Re: [GENERAL] Building with MinGW issue

2013-09-27 Thread Muhammad Bashir Al-Noimi
Postgresql built by MSVC ( libpq.lib and libpq.dll )!!! -- Best Regards, Muhammad Bashir Al-Noimi -- 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] Building with MinGW issue

2013-09-26 Thread Muhammad Bashir Al-Noimi
On 09/24/2013 02:57 AM, Adrian Klaver wrote: Sort of late in the thread to ask this, but any reason you are not using the precompiled binaries? I couldn’t find Postgresql binaries built by MinGW... Do you know if these binaries already exist? -- Best Regards, Muhammad Bashir Al-Noimi

Re: [GENERAL] Building with MinGW issue

2013-09-23 Thread Muhammad Bashir Al-Noimi
ble to built by MinGW under Windows7 32bit! -- Best Regards, Muhammad Bashir Al-Noimi -- 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] Building with MinGW issue

2013-09-23 Thread Muhammad Bashir Al-Noimi
Windows 7 32bit! -- Best Regards, Muhammad Bashir Al-Noimi

Re: [GENERAL] Building with MinGW issue

2013-09-23 Thread Muhammad Bashir Al-Noimi
me/mbnoimi/postgresql-9.1.9/src/port' make[1]: *** [all-port-recurse] Error 2 make[1]: Leaving directory `/home/mbnoimi/postgresql-9.1.9/src' make: *** [all-src-recurse] Error 2 -- Best Regards, Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Building with MinGW issue

2013-09-22 Thread Muhammad Bashir Al-Noimi
x27;t work! $ ./configure --without-zlib --with-openssl --with-includes=C:/OpenSSL-Win32/include --with-libraries=C:/OpenSSL-Win32/lib/MinGW -- Best Regards, Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Building with MinGW issue

2013-09-22 Thread Muhammad Bashir Al-Noimi
On 09/21/2013 07:07 PM, Adrian Klaver wrote: On 09/21/2013 07:45 AM, Muhammad Bashir Al-Noimi wrote: Yes,I build using mingw/msys under Windows with administrator permission Please reply to list also. Building software on Windows is not one of my strong points, so keeping this conversation

[GENERAL] Building with MinGW issue

2013-09-21 Thread Muhammad Bashir Al-Noimi
can I fix this issue? P.S. I use the following options for configuring call: $ ./configure --without-zlib --with-openssl --with-includes=C:/OpenSSL-Win32/include --with-libraries=C:/OpenSSL-Win32/lib /MinGW -- Best Regards, Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list

Re: [GENERAL] PG9.1 Static build over Windows

2013-09-15 Thread Muhammad Bashir Al-Noimi
On 09/10/2013 05:55 PM, Muhammad Bashir Al-Noimi wrote: Howdy, I want to link Postgresql client to my Qt project but I noticed that C:/PostgreSQL/9.1/lib/libpq.lib points to dynamic libaray (libpq.dll) which is not suiatble for static linking. How can I link statically my application with

[GENERAL] PG9.1 Static build over Windows

2013-09-10 Thread Muhammad Bashir Al-Noimi
kit: Satic-postgresql) When executing step 'Make' 17:12:37: Elapsed time: 00:22. Thanks in advance for help. -- Best Regards Muhammad Bashir Al-Noimi

Re: [GENERAL] pgAdmin for ubuntu

2013-07-17 Thread Muhammad Bashir Al-Noimi
On Wed, Jul 17, 2013 at 4:10 PM, Vincenzo Romano wrote: > Did you run "apt-get update" once you did che change? sure yes. -- Best Regards Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subsc

Re: [GENERAL] pgAdmin for ubuntu

2013-07-17 Thread Muhammad Bashir Al-Noimi
ary-amd64_Packages Hash Sum mismatch Failed to fetch bzip2:/var/lib/apt/lists/partial/archive.ubuntu.com_ubuntu_dists_quantal-updates_main_binary-i386_Packages Hash Sum mismatch Some index files failed to download. They have been ignored, or old ones used instead. -- Best Regards Muhammad Bashir

[GENERAL] pgAdmin for ubuntu

2013-07-17 Thread Muhammad Bashir Al-Noimi
build pgAdmin from the source code. -- Best Regards Muhammad Bashir Al-Noimi -- 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] Upgrading from Pg 9.1 to 9.2

2013-07-17 Thread Muhammad Bashir Al-Noimi
On Tue, Jul 16, 2013 at 11:52 PM, salah jubeh wrote: > Also have a look here > > http://wiki.postgresql.org/wiki/Using_pg_upgrade_on_Ubuntu/Debian Thanks a lot, I could successfully upgrade my server -- Best Regards Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing li

Re: [GENERAL] Upgrading from Pg 9.1 to 9.2

2013-07-16 Thread Muhammad Bashir Al-Noimi
xample it doens't mentioed what if I need to use pg_upgrade for bin dir which located in complete different path than Postgresql installer. So I'm lookinhg for specified steps not general information because I don't want to damage my data -- Best Regards Muhammad Bashir Al-Noimi --

[GENERAL] Upgrading from Pg 9.1 to 9.2

2013-07-16 Thread Muhammad Bashir Al-Noimi
tall postgresql-9.2 sudo apt-get upgrade Is there any specified steps I've to do? -- Best Regards Muhammad Bashir Al-Noimi -- 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] Force ssl connection

2013-07-10 Thread Muhammad Bashir Al-Noimi
ing ssl". So this will connect without an error both with > and without ssl. > > If you want to enforce ssl, use sslmode=require. > If you want to enforce non-ssl, use sslmode=disable. This is exactly what I'm looking for... thanks a lot it works perfectly. -- Best Regards M

Re: [GENERAL] Force ssl connection

2013-07-10 Thread Muhammad Bashir Al-Noimi
if (!db.open()) qDebug() << "Unable to connect!"; else qDebug() << "connected."; -- Best Regards Muhammad Bashir Al-Noimi -- 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] Force ssl connection

2013-07-10 Thread Muhammad Bashir Al-Noimi
0 md5 -- Best Regards Muhammad Bashir Al-Noimi -- 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] Force ssl connection

2013-07-09 Thread Muhammad Bashir Al-Noimi
On 07/09/2013 07:54 PM, Jeff Janes wrote: On Tue, Jul 9, 2013 at 10:02 AM, Muhammad Bashir Al-Noimi wrote: So may you please be more specific, what's wrong in my configurations? My pg_hba.conf content is: local all postgrespeer local

Re: [GENERAL] Force ssl connection

2013-07-09 Thread Muhammad Bashir Al-Noimi
all 0.0.0.0/0 reject -- Best Regards Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Force ssl connection

2013-07-08 Thread Muhammad Bashir Al-Noimi
uot;postgres"); db.setPassword(""); db.setPort(5432); db.setConnectOptions("requiressl=1"); if (!db.open()) { qDebug() << "Unable to connect!"; } -- Best Regards, Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@pos

Re: [GENERAL] spanish locale question

2012-05-04 Thread Al Eridani
e 'leon'. What Tulio is saying is that 'leon' and 'león' are the same thing from the point of view of sorting in Spanish, but his PostgreSQL seems to think that 'leon' goes before 'león'. Al -- 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] Silent installer in Windows

2010-06-15 Thread M. Bashir Al-Noimi
c:\pgData --superpassword admin On Mon, Jun 14, 2010 at 9:55 PM, Sachin Srivastava < sachin.srivast...@enterprisedb.com> wrote: > In the One-Click Installer for PostgreSQL use the CLI option, --mode > unattended for more options see --help. > > > On 6/15/10 12:45 AM, M.

Re: [GENERAL] Does enterprisedb.com down?

2010-06-15 Thread M. Bashir Al-Noimi
Thanks All, this thread moved now to another mailing list for discussing this problem with EnterpriseDB folks (Bruce Momjian and others). 2010/6/15 Magnus Hagander > On Tue, Jun 15, 2010 at 07:21, M. Bashir Al-Noimi > wrote: > > On 15/06/2010 06:00 ص, John Gage wrote: > > &

Re: [GENERAL] Does enterprisedb.com down?

2010-06-14 Thread M. Bashir Al-Noimi
in this email or any > attachment and is not liable for any errors, defects, omissions, viruses > or for resultant loss or damage, if any, direct or indirect." > > > > > > -- Best Regards Muhammad Bashir Al-Noimi My Blog: http://mbnoimi.net

Re: [GENERAL] Does enterprisedb.com down?

2010-06-14 Thread M. Bashir Al-Noimi
source? -- Best Regards Muhammad Bashir Al-Noimi My Blog: http://mbnoimi.net <> -- 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] Does enterprisedb.com down?

2010-06-14 Thread M. Bashir Al-Noimi
lkins || http://www.rasadam.com On 14 June 2010 22:45, M. Bashir Al-Noimi <ad...@mbnoimi.net> wrote: Hi folks, I tried to visit enterprisedb.com yesterday and today but I couldn't the browser gave me th

[GENERAL] Does enterprisedb.com down?

2010-06-14 Thread M. Bashir Al-Noimi
o I'm wondering does enterprisedb.com down? -- Best Regards Muhammad Bashir Al-Noimi My Blog: http://mbnoimi.net <> -- 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] Unable to install pg in Win (MVR error)

2010-06-14 Thread M. Bashir Al-Noimi
On 15/06/2010 02:26 ?, Dave Page wrote: On Mon, Jun 14, 2010 at 11:33 PM, M. Bashir Al-Noimi mailto:ad...@mbnoimi.net>> wrote: Wow, I catch installer bug. This problem related to executing .vbs files because of that whole installing process failed. In the attachmen

Re: [GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread M. Bashir Al-Noimi
specifying "--install_runtimes 0", What is the error code returned by the MS VC++ Runtime installer. You can check that in the log file (%TEMP%\bitrock_installer_.log). On 6/15/10 2:17 AM, M. Bashir Al-Noimi wrote: On 14/06/2010 08:43 م, Dave Page wrote: On M

Re: [GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread M. Bashir Al-Noimi
On 14/06/2010 11:16 م, Dave Page wrote: On Mon, Jun 14, 2010 at 8:47 PM, M. Bashir Al-Noimi <mailto:ad...@mbnoimi.net>> wrote: On 14/06/2010 08:43 م, Dave Page wrote: On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi mailto:ad...@mbnoimi.net>> wrote:

Re: [GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread M. Bashir Al-Noimi
On 14/06/2010 08:43 م, Dave Page wrote: On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi <ad...@mbnoimi.net> wrote: Hi All, As shown in the following screenshot I couldn't install pg in Windows because it couldn't install Micros

Re: [GENERAL][SOLVED] Silent installer in Windows

2010-06-14 Thread M. Bashir Al-Noimi
Thanks Sachin On 14/06/2010 08:55 م, Sachin Srivastava wrote: In the One-Click Installer for PostgreSQL use the CLI option, --mode unattended for more options see --help. On 6/15/10 12:45 AM, M. Bashir Al-Noimi wrote: Hi folks, I want to install ps silentely in Windows how I can do it

[GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread M. Bashir Al-Noimi
Muhammad Bashir Al-Noimi My Blog: http://mbnoimi.net <> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Silent installer in Windows

2010-06-14 Thread M. Bashir Al-Noimi
ger available as mentioned in its home page. -- Best Regards Muhammad Bashir Al-Noimi My Blog: http://mbnoimi.net <> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Problem with large bytea fields in windows

2007-07-21 Thread Al Rosenthal
Thank you for any help Al Rosenthal arosnethal at AtlantaHand dot com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message ca

[GENERAL] Version 8.2 for HP-UX

2007-01-12 Thread Al Balmer
Does anyone know where to get postgreSQL 8.2 binaries or depot for HP-UX? We have a problem because of non-conforming backslash handling, and I understand that's been fixed in 8.2. -- Al Balmer Sun City, AZ ---(end of broadcast)--- TIP 4: Hav

Re: [GENERAL] book for postgresql

2004-02-19 Thread Al Hulaton
t our website below. And since the book was written for 7.1, we put up a simultaneous search of the book with the current official PostgreSQL techdocs. -- Best, Al Hulaton| Sr. Account Engineer | Command Prompt, Inc. 503.667.4564 | [EMAIL PROTECTED] Home of Mammoth Replicator for Postg

Re: [GENERAL] Support.

2004-02-19 Thread Al Hulaton
cause different sized companies need different levels of support. I think you'll find many postgres consultants will offer the same. -- Best, Al Hulaton| Sr. Account Engineer | Command Prompt, Inc. 503.667.4564 | [EMAIL PROTECTED] Home of Mammoth Replicator for PostgreSQL Manag

Re: [GENERAL] Books for PostgreSQL?

2003-08-28 Thread Al Hulaton
following this thread with interest. -- Best, Al Hulaton| Sr. Account Engineer | Command Prompt, Inc. 503.222.2783 | [EMAIL PROTECTED] Home of Mammoth PostgreSQL and 'Practical PostgreSQL' Managed PostgreSQL, Linux services and consulting Read and Search O'Reilly's

[GENERAL] Re: Which Front End for Postgresql

2001-05-18 Thread Al Frick
kup hardware and software for this environment? Thansks for the reply, Al Frick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] Problem installing Postgresql

2001-04-30 Thread Al
I am running OpenLinux 2.3 (Caldera) out of the box. Trying to install PostGreSQL I seem to be unable to get past the 'make' process. Errors I get at the end of the process are: make[3]: *** [pg_backup_custom.o] Error 1 make[3]: Leaving directory `/addon/postgresql-7.1/src/bin/pg_dump' make[2

[GENERAL] Question about SELECT FOR UPDATE in transaction, isolation level

2001-04-07 Thread Al
o this in PostgreSQL? Al. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] How to Retrieve Just One Record ?

1999-02-24 Thread Aharon (Al) Schkolnik
Hi. I'd like to do select * from mytable but just get one record. I don't even care which record. Any ideas ? Thanks. -- The day is short, and the work is great, | Aharon Schkolnik and the laborers are lazy, and the reward| [EMAIL PROTECTED] is great, and the Master o