Re: Changing work_mem

On 08/14/2019 11:42 AM, Laurenz Albe wrote: rihad wrote: Sorry, I just decreased work_mem back to 256MB, reloaded, and instantly started seeing 82mb temp file creation, not 165mb as was usual with work_mem=512MB. So it indeed was applied immediately. Really weird figures ) Increased work_mem

Re: Changing work_mem

rihad wrote: > > Sorry, I just decreased work_mem back to 256MB, reloaded, and > > instantly started seeing 82mb temp file creation, not 165mb as was > > usual with work_mem=512MB. > > > > So it indeed was applied immediately. > > Really weird figures ) > > Increased work_mem to 768MB and

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Rich Shepard wrote: Thanks, Adrian. This looks like it has all the information I need. Adrian, Off the mail list. I'm reading that metadata document and it seems to me that it's not well constructed. Perhaps this is an Access thing[1]; perhaps the DBA's have limited

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Rich Shepard wrote: Off the mail list. Sorry all. I thought it went to only Adrian. Rich

RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg

Hi Adrian , We have the below output. What we need to change. bash-4.2$ ora2pg -c ora2pg.bidder.conf -t SHOW_ENCODING Current encoding settings that will be used by Ora2Pg: Oracle NLS_LANG AMERICAN_AMERICA.AL32UTF8 Oracle NLS_NCHAR AL32UTF8 Oracle NLS_TIMESTAMP_FORMAT

Re: GIST/GIN index not used with Row Level Security

> > > > I've updated word_similarity_op(text,text) to be leakproof, and > > pg_proc agrees it is. I'm assuming word_similarity_op() is equivalent to > > <%, though I haven't found explicit confirmation. However, using > > word_similarity() instead of <% on a 100k row table, without any RLS > >

Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg

On 8/14/19 2:39 AM, Daulat Ram wrote: Hi Adrian , We have the below output. What we need to change. I am not an ora2pg user so I don't know what to suggest for below. I would say the best thing to do would be to file an issue here: https://github.com/darold/ora2pg/issues Along with the

Re: Converting Access .mdb to postgres

On 8/14/19 11:11 AM, Rich Shepard wrote: On Wed, 14 Aug 2019, Adrian Klaver wrote: Have you looked at: https://www.streamnet.org/wp-content/uploads/2018/06/StreamNetExchangeStandard2018-1.doc Thanks, Adrian. This looks like it has all the information I need. Under which menu did you find

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: Here: https://www.streamnet.org/data/downloadable-data/ Link: Data Exchange Standard (DES). Adrian, Then I missed it when I was in that subdirectory. Thanks, Rich

Converting Access .mdb to postgres

I have the need to convert a flat-file Access database to postgres. I've exported the .mdb tables using mdbtools. There's an accompanying metadata PDF with column names and data types for each of the 84 tables, but no description of the tables or column headings. I've asked the agency to provide

Re: Converting Access .mdb to postgres

On 8/14/19 10:09 AM, Rich Shepard wrote: I have the need to convert a flat-file Access database to postgres. I've exported the .mdb tables using mdbtools. There's an accompanying metadata PDF with column names and data types for each of the 84 tables, but no description of the tables or column

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: So you have the tables in Postgres, correct? Adrian, Not yet. I have the schema extracted using mdb-schema. I did something similar with the USDA Nutrient database(with notion of making it a test dataset): https://ndb.nal.usda.gov/ndb/doc/index

Re: Converting Access .mdb to postgres

On 8/14/19 10:45 AM, Rich Shepard wrote: On Wed, 14 Aug 2019, Adrian Klaver wrote: So you have the tables in Postgres, correct? Adrian, Not yet. I have the schema extracted using mdb-schema. I did something similar with the USDA Nutrient database(with notion of making it a test dataset):

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Roger De Four wrote: The easy way - just send it to me. The more challenging way requires using several tools like excel or Open Office. Roger, I could post the .mdb on a cloud web site for download; it's 565M uncompressed; the xz-compressed tarball is a mere 42M. When

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: Have you looked at: https://www.streamnet.org/wp-content/uploads/2018/06/StreamNetExchangeStandard2018-1.doc Adrian, Not yet, but I will. Didn't see it when I went to the data pages. Thanks, Rich

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Rich Shepard wrote: I could post the .mdb on a cloud web site for download; it's 565M uncompressed; the xz-compressed tarball is a mere 42M. Will post the URL for the tarball Real Soon Now. Here it is for anyone interested: . Rich

Re: Converting Access .mdb to postgres

A few years ago I tried to take an app someone had written for us in Access years ago and convert it to Postgres. It seemed like for every rule I tried there were a handful of exceptions. We wound up just rewriting the app and not trying to export the data from the previous one. I hope your

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: Have you looked at: https://www.streamnet.org/wp-content/uploads/2018/06/StreamNetExchangeStandard2018-1.doc Thanks, Adrian. This looks like it has all the information I need. Under which menu did you find this? I had looked in the Data and Resources

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Michael Nolan wrote: It seemed like for every rule I tried there were a handful of exceptions. We wound up just rewriting the app and not trying to export the data from the previous one. Mike, This is not surprising. My interest is in the data, not the application. Much

How to conditionally change the 2nd part of a full join

I need to obtain a single record from 2 records in the same table grouping for a key, say id    value    value2 1 2            5 1    2        7 the result would be 1    2    5    7 and that works fine with a full join: SELECT * FROM (SELECT idp, data, i1, i2, m1, m2 from tblwk WHERE