[GENERAL] education: european project + optionally 1 non-european partner

2014-03-01 Thread Wim Bertels
Hallo, context: Higher Education (Bachelor and Master degrees) i'am considering forming what the EU calls a strategic partnership. This can be used to get funding for this partnership. * Roadmap: project needs to be written, await for approval, then execute the project (ie the actions that we're

Re: [GENERAL] pgrestore command

2014-03-01 Thread Michael Paquier
On Sat, Mar 1, 2014 at 3:23 AM, John R Pierce wrote: > On 2/28/2014 5:06 AM, Michael Paquier wrote: >> >> You could expect a loss of 20% at I/O level by using a virtualized >> environment compared to a physical server with similar hardware (rule >> of thumb, number more or less general by experien

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Vincent Veyron
On Fri, 28 Feb 2014 16:03:39 -0800 (PST) Rich Shepard wrote: > > And, I discovered 'jet-tool' on code.google.com. That'll do the job, I > > believe. > >Well, it won't work: it's a M$ .exe file and the source is apparently in > some M$-type of Pascal. > I've had success with mdbtools, but

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Rich Shepard
On Sat, 1 Mar 2014, Vincent Veyron wrote: I've had success with mdbtools, but on older version of Jet database files and small files. I've haven't tested it on Access 2007+. Vincent, I suspect this file is in the current Access version. I understand you run linux, but if you can get hold

Re: [GENERAL] 'tuple concurrently updated' error when granting permissions

2014-03-01 Thread Adrian Klaver
On 02/27/2014 06:54 PM, Jason Daly wrote: Hi, When I attempt to execute the non-query "GRANT SELECT ON TABLE . TO ", I occasionally encounter an exception from postgresql, 'tuple concurrently updated'. I think the tuple it is referring to is the role. Our app is multi-threaded, and it is very p

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Rich Shepard
On Fri, 28 Feb 2014, John McKown wrote: Is this data generally available? If so, then can you tell us how to get a copy of the data? If we can get a copy, it might be able to figure out how to read it. John, Here's the URL: R

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Adrian Klaver
On 03/01/2014 06:41 AM, Rich Shepard wrote: On Fri, 28 Feb 2014, John McKown wrote: Is this data generally available? If so, then can you tell us how to get a copy of the data? If we can get a copy, it might be able to figure out how to read it. John, Here's the URL:

Re: [GENERAL] Replacing Ordinal Suffixes

2014-03-01 Thread Alvaro Herrera
George Weaver wrote: > Hi Ian, > > I just got that as well - awesome! http://xkcd.com/1313/ -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Rich Shepard
On Sat, 1 Mar 2014, Adrian Klaver wrote: FYI in the Summary / Abstract at the above link there is this: "If you would like these data in a different format or would like help in using this file, please contact.." I missed seeing that. Thanks. Rich -- Sent via pgsql-general mailing lis

Re: [GENERAL] high throughput 9.3, master/slave question

2014-03-01 Thread bricklen
On Fri, Feb 28, 2014 at 1:54 PM, Matthew Chambers wrote: > > Initially, I had my application servers using the slave for short, read > only queries, but this turned out to be highly unstable. The slave would > start refusing connections, and the logs would fill with: > > ERROR: canceling statemen

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Bret Stern
FYI, Pretty sure Apache Office Base has native support to open Access.mdb files on a linux box -- 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] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Michael Nolan
I think that PHP has modules (eg, PEAR) that can read MS Access database files, and once you have it in an array you can create INSERT statements for PostgreSQL, including cleaning up any data format issues (eg, dates of 00-00-) -- Mike Nolan On Fri, Feb 28, 2014 at 6:21 PM, Rich Shepard wrot

Re: [GENERAL] 'tuple concurrently updated' error when granting permissions

2014-03-01 Thread Tom Lane
Adrian Klaver writes: > On 02/27/2014 06:54 PM, Jason Daly wrote: >> When I attempt to execute the non-query "GRANT SELECT ON TABLE >> . TO ", I occasionally encounter an exception from >> postgresql, 'tuple concurrently updated'. > My guess this is covered here: > http://rhaas.blogspot.com/2013/

Re: [GENERAL] Replacing Ordinal Suffixes

2014-03-01 Thread George Weaver
Hi All, From: James Cloos The E'' syntax eats your backslashes. For that version, try just: SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'),'(\d)(st|nd|rd|th)', '\1', 'g'); Actually, I found that the double backslashes are required whether the E is used or not: development=# se

Re: [GENERAL] Replacing Ordinal Suffixes

2014-03-01 Thread Tom Lane
"George Weaver" writes: > Actually, I found that the double backslashes are required whether the E is > used or not: You must be using a relatively old PG version then. Default behavior since around 9.1 has been that backslashes aren't special except in E'' strings. reg

Re: [GENERAL] Replacing Ordinal Suffixes

2014-03-01 Thread George Weaver
Actually, I found that the double backslashes are required whether the E is used or not: You must be using a relatively old PG version then. Default behavior since around 9.1 has been that backslashes aren't special except in E'' strings. Hmm. development=# select version();

[GENERAL] PQunescapebytea not reverse of PQescapebytea?

2014-03-01 Thread Karthik Segpi
Hi - I have a 'bytea' column in the database, onto which my custom C application is inserting encrypted data. Before inserting, I am calling 'PQescapebytea()' to escape the ciphertext. However, after SELECT, the data needs to be 'un-escaped' before attempting to decrypt. I am trying to 'un-escape'

Re: [GENERAL] Replacing Ordinal Suffixes

2014-03-01 Thread Steve Atkins
On Mar 1, 2014, at 11:45 AM, George Weaver wrote: > >> Actually, I found that the double backslashes are required whether the E is >> used or not: > >> You must be using a relatively old PG version then. Default behavior >> since around 9.1 has been that backslashes aren't special except >> i

Re: [GENERAL] PQunescapebytea not reverse of PQescapebytea?

2014-03-01 Thread Tom Lane
Karthik Segpi writes: > I have a 'bytea' column in the database, onto which my custom C application > is inserting encrypted data. Before inserting, I am calling > 'PQescapebytea()' to escape the ciphertext. However, after SELECT, the data > needs to be 'un-escaped' before attempting to decrypt. I

Re: [GENERAL] Replacing Ordinal Suffixes

2014-03-01 Thread George Weaver
- Original Message - From: Steve Atkins I suspect you have standard_conforming_strings set to off (it defaults to on in 9.1), possibly for backwards compatibility to support an app you’re using that’s not been updated, possibly accidentally. You're right - it was off (now On). Th