Re: [GENERAL] [BUGS] BUG #14285: Chinese locale and windows

2016-08-09 Thread Rader, David
-- David Rader dav...@openscg.com On Tue, Aug 9, 2016 at 10:23 AM, wrote: > Logged by: Nicolas David > Email address: nicolas.da...@verosoftware.com > PostgreSQL version: 9.2.5 > Operating system: Windows 10 > Description: > > Dear All, > > we have a chinese customer that have m

[GENERAL] Re: [GENERAL] Does PostgreSQL support BIM(Building Information Modeling) storage?

2016-12-06 Thread Rader, David
You should ask on the PostGIS list - they will be closer to this: https://lists.osgeo.org/mailman/listinfo/postgis-users -- David Rader dav...@openscg.com On Mon, Dec 5, 2016 at 9:05 PM, sunpeng wrote: > Does PostgreSQL support BIM(Building Information Modeling) storage?Or how? > I can only f

Re: [GENERAL] Read/Write operation counts

2017-01-18 Thread Rader, David
On Wed, Jan 18, 2017 at 4:10 PM, John R Pierce wrote: > On 1/18/2017 1:02 PM, Anirudh Jayakumar wrote: > >> Is there a way to retrieve the total read/write operations initiated by a >> PG server. I'm looking for measuring the IOPS of a server over a period of >> time. >> > > postgres itself doesn

Re: [GENERAL] migrate Sql Server database to PostgreSql

2017-01-20 Thread Rader, David
-- David Rader dav...@openscg.com On Thu, Jan 19, 2017 at 8:56 AM, Kenneth Marshall wrote: > On Thu, Jan 19, 2017 at 03:29:34PM +1100, Venkata B Nagothi wrote: > > On Thu, Jan 19, 2017 at 6:17 AM, PAWAN SHARMA > > > wrote: > > > > > Hello All, > > > > > > I am using postgres 9.5 enterprise edi

Re: [GENERAL] Postgres 9.5 - password for new windows user

2016-02-03 Thread Rader, David
Sofy - One of your early emails said setting up a DB from the command line. Did you run the installer from the command line or as a windows application? If you want to try a different Windows graphical installer, you can try the one from BigSQL: http://www.bigsql.org/se/postgresql/packages.jsp -d

Re: [GENERAL] Re: could not migrate 8.0.13 database with large object data to 9.5.1

2016-03-04 Thread Rader, David
Wow -- you have an old db version there! When doing a little research, I found that back in 2005 you actually had the same basic issue - that the way you were using the "lo" contrib module in 7.x and 8.0 was not supported in 8.1 anymore: http://www.postgresql.org/message-id/439ffa3f.c5f7.004...@nsa

Re: [GENERAL] Postgresql-fdw

2016-05-23 Thread Rader, David
On Mon, May 23, 2016 at 1:52 AM, aluka raju wrote: I have data storage in flat files (structured and unstructured) . I want to run sql queries on that , so i am looking in to postgresql how to use fdw on the data that i have. You could use the file_fdw to "attach" the files as foreign tables. At

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

2017-02-13 Thread Rader, David
How about using pg_isready? https://www.postgresql.org/docs/current/static/app-pg-isready.html -- David Rader dav...@openscg.com On Sun, Feb 12, 2017 at 12:23 PM, Nikolai Zhubr wrote: > Hello all, > > In order to locate the problem more precisely, I'd like to prepare a test, > involving some p

Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

2017-02-14 Thread Rader, David
-- David Rader dav...@openscg.com On Tue, Feb 14, 2017 at 5:28 AM, Nikolai Zhubr wrote: > 14.02.2017 12:47, John R Pierce: > >> On 2/13/2017 11:03 PM, Nikolai Zhubr wrote: >> >>> Now I'd like to locate a CPU eater more precisely - supposedly there >>> is some issue with communication, that is wh

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-24 Thread Rader, David
On Sun, Apr 23, 2017 at 10:33 PM, Tatsuo Ishii wrote: > > Andres Freund writes: > >> On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: > >>> Some systems (Presto) are still using protocol 2, and I need to > understand > >>> the scope of changes in the middleware to support protocol 2. > >