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

On 02/28/2014 04:34 PM, Rich Shepard wrote: On Fri, 28 Feb 2014, Adrian Klaver wrote: Well JET is the database engine for Access and mdb is one of the file format extensions for Access database files. JET has been used in other MS products and Access has used different file formats(extensions)

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

On 02/28/2014 04:10 PM, Thomas Kellerer wrote: Rich Shepard wrote on 01.03.2014 00:21: I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anyt

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

On Sat, 1 Mar 2014, Ian Lawrence Barwick wrote: Not sure if this will be of use, but there are a couple of links here: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access I'll post it anyway in case someone comes across this thread in the future.

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

On Sat, 1 Mar 2014, Thomas Kellerer wrote: No, not within psql, but from within a Java/JDBC based query tool (such as my SQL Workbench) Oh. OK. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.

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

On Fri, 28 Feb 2014, Adrian Klaver wrote: Well JET is the database engine for Access and mdb is one of the file format extensions for Access database files. JET has been used in other MS products and Access has used different file formats(extensions) over the years. So you may be in for a chore

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

2014-03-01 9:34 GMT+09:00 Rich Shepard : > On Fri, 28 Feb 2014, Adrian Klaver wrote: > >> Well JET is the database engine for Access and mdb is one of the file >> format extensions for Access database files. JET has been used in other MS >> products and Access has used different file formats(extens

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

Rich Shepard wrote on 01.03.2014 01:33: On Sat, 1 Mar 2014, Thomas Kellerer wrote: It's not clear to me what exactly you are trying to do. Or are you just trying to copy the data into the Postgres database? If the latter you could try one of the JDBC based query tools to export or copy the d

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

On Fri, 28 Feb 2014, Adrian Klaver wrote: Well JET is the database engine for Access and mdb is one of the file format extensions for Access database files. JET has been used in other MS products and Access has used different file formats(extensions) over the years. So you may be in for a chore

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

On Sat, 1 Mar 2014, Thomas Kellerer wrote: It's not clear to me what exactly you are trying to do. Or are you just trying to copy the data into the Postgres database? If the latter you could try one of the JDBC based query tools to export or copy the data using the UCanAccess JDBC driver for

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

Rich Shepard wrote on 01.03.2014 00:21: I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anything useful; the closest was a thread from this

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

On 02/28/2014 03:58 PM, Rich Shepard wrote: On Fri, 28 Feb 2014, Adrian Klaver wrote: The only software I could find to directly read MDB files on Linux is : http://mdbtools.sourceforge.net/ Not sure what version of MDB you have and whether the above is current enough to read them. Otherwise yo

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

On Fri, 28 Feb 2014, 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. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql

Re: [GENERAL] Replacing Ordinal Suffixes

> "GW" == George Weaver writes: GW> SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'), GW> E'(\d)(st|nd|rd|th)', E'\1', 'g'); GW> regexp_replace GW> GW> 300 north 126th street GW> (1 row) The E'' syntax eats your backslashes. For that version, try just: SEL

Re: [GENERAL] Replacing Ordinal Suffixes

From: Ian Lawrence Barwick - Original Message - From: Steve Atkins On Feb 28, 2014, at 2:43 PM, George Weaver wrote: >Maybe this? >select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)', >'\1', 'gi'); Hi Steve, Thanks, but no luck: select regexp_replace('300 No

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

On Fri, 28 Feb 2014, Adrian Klaver wrote: The only software I could find to directly read MDB files on Linux is : http://mdbtools.sourceforge.net/ Not sure what version of MDB you have and whether the above is current enough to read them. Otherwise you need to crank up an Access instance and go

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

On 02/28/2014 03:21 PM, Rich Shepard wrote: I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anything useful; the closest was a thread from t

Re: [GENERAL] Replacing Ordinal Suffixes

2014-03-01 8:16 GMT+09:00 George Weaver : > >> - Original Message - From: Steve Atkins > > >> On Feb 28, 2014, at 2:43 PM, George Weaver wrote: >> >> >Maybe this? >> >> >select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)', >> >'\1', 'gi'); >> >> Hi Steve, >> >> Thanks, b

Re: [GENERAL] Replacing Ordinal Suffixes

- Original Message - From: Steve Atkins To: pgsql-general Sent: Friday, February 28, 2014 4:17 PM Subject: Re: [GENERAL] Replacing Ordinal Suffixes On Feb 28, 2014, at 2:04 PM, George Weaver wrote: Hi list, I'm stumped. I am trying to use Regexp_Replace to replace ordinal suffixes

Re: [GENERAL] Josh's Comments on Hstore / Jsonb

On 26/02/14 09:32, Merlin Moncure wrote: On Tue, Feb 25, 2014 at 3:43 PM, john.tiger wrote: Somehow my comments didn't go thru on the soup blog but wanted to throw in more support for this patch Josh, you are so right on the money. An ACID compliant db that

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

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 possible for more than one thread to be attem

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

I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anything useful; the closest was a thread from this mail list in 2000 on how to send a postgres

Re: [GENERAL] Replacing Ordinal Suffixes

- Original Message - From: Steve Atkins On Feb 28, 2014, at 2:43 PM, George Weaver wrote: >Maybe this? >select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)', >'\1', 'gi'); Hi Steve, Thanks, but no luck: select regexp_replace('300 North 126th Street', E'(\d+)(?:

Re: [GENERAL] Replacing Ordinal Suffixes

On Feb 28, 2014, at 2:43 PM, George Weaver wrote: > From: Steve Atkins > > >Maybe this? > > >select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)', > >'\1', 'gi'); > > Hi Steve, > > Thanks, but no luck: > > select regexp_replace('300 North 126th Street', E'(\d+)(?:st|nd|rd

Re: [GENERAL] Replacing Ordinal Suffixes

From: Steve Atkins On Feb 28, 2014, at 2:04 PM, George Weaver wrote: > Hi list, > > I'm stumped. > > I am trying to use Regexp_Replace to replace ordinal suffixes in addresses > (eg have '126th' want '126') for comparison purposes. So far no luck. > > I have found that > > SELECT REGEXP_REPLAC

Re: [GENERAL] Replacing Ordinal Suffixes

From: Paul Jungwirth Try this: SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'), '(\d)(st|nd|rd|th)', '\1', 'g'); Hi Paul, No luck... SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'), E'(\d)(st|nd|rd|th)', E'\1', 'g'); regexp_replace 300 north 126t

Re: [GENERAL] Replacing Ordinal Suffixes

This is a kick *ss forum. I must say. On Fri, 2014-02-28 at 14:17 -0800, Steve Atkins wrote: > On Feb 28, 2014, at 2:04 PM, George Weaver wrote: > > > Hi list, > > > > I'm stumped. > > > > I am trying to use Regexp_Replace to replace ordinal suffixes in addresses > > (eg have '126th' want

Re: [GENERAL] Replacing Ordinal Suffixes

On Feb 28, 2014, at 2:04 PM, George Weaver wrote: > Hi list, > > I'm stumped. > > I am trying to use Regexp_Replace to replace ordinal suffixes in addresses > (eg have '126th' want '126') for comparison purposes. So far no luck. > > I have found that > > SELECT REGEXP_REPLACE(LOWER('30

Re: [GENERAL] Replacing Ordinal Suffixes

Try this: SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'), '(\d)(st|nd|rd|th)', '\1', 'g'); Note that matching a number is \d not /D: backslash, not forward slash, and lowercase d not uppercase. \d means a digit, \D means anything except a digit. Also, I don't think Postgres supports posit

[GENERAL] Replacing Ordinal Suffixes

Hi list, I'm stumped. I am trying to use Regexp_Replace to replace ordinal suffixes in addresses (eg have '126th' want '126') for comparison purposes. So far no luck. I have found that SELECT REGEXP_REPLACE(LOWER('300 North 126th Street'), '(?!/D)(st|nd|rd|th)', '', 'g'); regexp_replace -

[GENERAL] high throughput 9.3, master/slave question

Hi, I have a postgres server that is fairly high traffic. (about 5MB/second in writes to SSD backed Netapp NFS storage). The outbound network traffic for this machine averages 61MB/second, but gets over 250MB/second during peal times. (includes data to slave + user requests) Initially, I h

Re: [GENERAL] pgrestore command

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 experience). and that could be 200% or more if there is IO and/or CPU co

Re: [GENERAL] Josh's Comments on Hstore / Jsonb

On Thu, Feb 27, 2014 at 6:16 PM, Brett Mc Bride wrote: > I'm in the process of prototyping a DB-backed REST web service as a > side-project. It's still early > days, but I've been handed a PHP/mysql setup. > After a bit of searching around, I thought that the exact combination above > (node.json/e

Re: [GENERAL] pgrestore command

On Fri, Feb 28, 2014 at 4:41 PM, Arun P.L wrote: > Hi > > Is there any chances for any performance issues with pg_restore when > changing the servers, like openvz, xen, etc.? You could expect a loss of 20% at I/O level by using a virtualized environment compared to a physical server with similar h