Re: [GENERAL] postgresql 9.5 upsert issue with nulls

On Tue, Oct 04, 2016 at 07:46:48PM +, Shaun McCready wrote: > Hello, > > I'm having an issue with using the new UPSERT feature in Postgres 9.5 > > I have a table that is used for aggregating data from another table. The > composite key is made up of 20 columns, 10 of which can be nullable. >

[GENERAL] postgresql 9.5 upsert issue with nulls

Hello, I'm having an issue with using the new UPSERT feature in Postgres 9.5 I have a table that is used for aggregating data from another table. The composite key is made up of 20 columns, 10 of which can be nullable. Below I have created a smaller version of the issue i'm having, specifically

[GENERAL] postgresql service is working but showing status failed

Everything looks and works as it should, just i am not getting the status opensips service as active (running) instead i am getting active (exited), what am i missing here? # netstat -pan|grep 5432 tcp0 0 0.0.0.0:54320.0.0.0:* LISTEN 589/postgres # /etc

Re: [GENERAL] PostgreSQL installation failure

On 9/16/2016 1:53 AM, thomas.deboben@rohde-schwarz.com wrote: psql: could not connect to server: Connection refused (0x274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? that says it all. Is the postgres service r

[GENERAL] PostgreSQL installation failure

Hello, I need some help on an installation issue with PostgreSQL 9.5.0.1 I have written a wix bootstrapper to install postgresql for our application. This has worked for different version, but now we get sometimes trouble with the installer as some sql scripts can't be executed during install. >

Re: [GENERAL] PostgreSQL GIN index not used when ts_query language is fetched from a column

On Thu, Sep 15, 2016 at 5:46 AM, Jaap Roes wrote: > I've got a table that stores some multilingual content: > > CREATE TABLE search ( > content text NOT NULL, > language regconfig NOT NULL, > fulltext tsvector > ); > CREATE INDEX search_fulltext ON search USING GIN(f

Re: [GENERAL] PostgreSQL GIN index not used when ts_query language is fetched from a column

> On 15 Sep 2016, at 14:46, Jaap Roes wrote: > > I've got a table that stores some multilingual content: > >CREATE TABLE search ( > content text NOT NULL, > language regconfig NOT NULL, > fulltext tsvector >); >CREATE INDEX search_fulltext ON search USING GIN(fulltext

[GENERAL] PostgreSQL GIN index not used when ts_query language is fetched from a column

I've got a table that stores some multilingual content: CREATE TABLE search ( content text NOT NULL, language regconfig NOT NULL, fulltext tsvector ); CREATE INDEX search_fulltext ON search USING GIN(fulltext); INSERT INTO search (language, content) VALUES

Re: [GENERAL] PostgreSQL Database performance

On 9/6/16 2:08 PM, Scott Marlowe wrote: checkpoint_completion_target = 0.9 Too high of a checkpoint completion target may cause buffers to get written out more often than needed. but it varies based on load etc. The odds on that don't seem to be terribly high. Even if that is a common occurre

Re: [GENERAL] PostgreSQL Database performance

On 9/2/2016 8:38 PM, Pradeep wrote: ... In task bar it is showing 2.7GB Utilization ... odd, the task bar doesn't show any sort of memory utilization on any of my windows systems.are you referring instead to the Task Manager ? Note the Windows Task Manager by default doesn't show shared

Re: [GENERAL] PostgreSQL Database performance

On Tue, Sep 6, 2016 at 11:12 PM, Pradeep wrote: > Dear Naveed, > > I am using PostgreSQL 9.3 version on Windows .After changing these > parameters, I have not seen any resource management utilization. > > I have observed before and after changing the parameter values ,it is not > reflecting the m

Re: [GENERAL] PostgreSQL Database performance

> > Thanks & Regards > > Pradeep Kanth > > Ext : 3026 > > > > *From:* Naveed Shaikh [mailto:naveed.sha...@enterprisedb.com] > *Sent:* 06 September, 2016 11:22 PM > *To:* Pradeep > *Cc:* pgsql-general@postgresql.org > *Subject:* Re: [GENERAL] PostgreSQL D

Re: [GENERAL] PostgreSQL Database performance

. So kindly let me ,whether it will impact the RAM utilization or not? Thanks & Regards Pradeep Kanth Ext : 3026 From: Naveed Shaikh [mailto:naveed.sha...@enterprisedb.com] Sent: 06 September, 2016 11:22 PM To: Pradeep Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgr

Re: [GENERAL] PostgreSQL Database performance

On Tue, Sep 6, 2016 at 1:18 PM, Steve Atkins wrote: > >> On Sep 6, 2016, at 12:08 PM, Scott Marlowe wrote: >> >> On Fri, Sep 2, 2016 at 9:38 PM, Pradeep wrote: >>> >>> max_connections = 100 >>> shared_buffers = 512MB >>> effective_cache_size = 24GB >>> work_mem = 110100kB >> >> This is WAY too h

Re: [GENERAL] PostgreSQL Database performance

On Fri, Sep 2, 2016 at 8:38 PM, Pradeep wrote: > Dear Team, > > > > Could you please help me, after changing the below parameters in > PostgreSQL configuration file it was not reflecting in OS level and also > Database performance is degrading. > What were they before you changed them? Do you

Re: [GENERAL] PostgreSQL Database performance

> On Sep 6, 2016, at 12:08 PM, Scott Marlowe wrote: > > On Fri, Sep 2, 2016 at 9:38 PM, Pradeep wrote: >> >> max_connections = 100 >> shared_buffers = 512MB >> effective_cache_size = 24GB >> work_mem = 110100kB > > This is WAY too high for work_mem. Work_mem is how much memory a > single sort

Re: [GENERAL] PostgreSQL Database performance

On Fri, Sep 2, 2016 at 9:38 PM, Pradeep wrote: > Dear Team, > > > > Could you please help me, after changing the below parameters in PostgreSQL > configuration file it was not reflecting in OS level and also Database > performance is degrading. > > > > Example: I am using Windows 2008 R2 server .F

Re: [GENERAL] PostgreSQL Database performance

o:pgsql-general-owner@ > postgresql.org] *On Behalf Of *Pradeep > *Sent:* Saturday, September 03, 2016 6:39 AM > *To:* pgsql-general@postgresql.org > *Subject:* [GENERAL] PostgreSQL Database performance >

Re: [GENERAL] PostgreSQL Database performance

ns.com/> http://www.jetbrains.com The Drive to Develop From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Pradeep Sent: Saturday, September 03, 2016 6:39 AM To: pgsql-general@postgresql.org Subject: [GENERAL] PostgreSQL Database performance

Re: [GENERAL] PostgreSQL Database performance

Which version of PostgreSQL are you using on your windows? Increasing work_mem can lead to far less disk-swapping, and therefore far quicker queries. However, it can cause problems if set too high, and should be constrained taking into account max_connections. The following calculation is what is

[GENERAL] PostgreSQL Database performance

Dear Team, Could you please help me, after changing the below parameters in PostgreSQL configuration file it was not reflecting in OS level and also Database performance is degrading. Example: I am using Windows 2008 R2 server .For PostgreSQL I have allocated 24GB RAM out of 32GB. However

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

This is now solved guys. There were three problems. 1 - I was looking for the logs on /var/lib/postgresql/9.2/main/pg_log. And it's wrong. On ubuntu, the logs are: /var/log/postgresql 2 - I just changed the max_stack_depth to the default DETAIL: "max_stack_depth" must not exceed 7680kB. > HINT

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

> > > Short version: > > That probably should be postgresql not postgres > > Long version: > > https://help.ubuntu.com/community/PostgreSQL > > >> > Yep.. my mistake.. /etc/init.d/postgresql start/stop/restart

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

On 8/2/2016 1:17 PM, Patrick B wrote: Ubuntu 16.04.1 LTS How did you install Postgres and from where? apt-get install postgresql-9.2 postgresql-contrib-9.2 dpkg -l postgresql When I start it, it doesn't start... Show the command you used to start it. /etc/init.d/postg

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

On 08/02/2016 01:17 PM, Patrick B wrote: 2016-08-03 8:13 GMT+12:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 08/02/2016 01:04 PM, Patrick B wrote: Hi guys, I've installed potgres on a Ubuntu machine. Postgres version? have a look on the subjec of this e

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

So, I found a log file on /var/log/postgres/ DETAIL: "max_stack_depth" must not exceed 7680kB. > HINT: Increase the platform's stack depth limit via "ulimit -s" or local > equivalent. > 2016-08-02 19:54:06.293 UTC|12960|FATAL: configuration file > "/etc/postgresql/9.2/main/postgresql.conf" cont

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-03 8:13 GMT+12:00 Adrian Klaver : > On 08/02/2016 01:04 PM, Patrick B wrote: > >> Hi guys, >> >> I've installed potgres on a Ubuntu machine. >> > > Postgres version? > have a look on the subjec of this email (9.2) > > Ubuntu version? > Ubuntu 16.04.1 LTS > > How did you install Postg

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

On 08/02/2016 01:04 PM, Patrick B wrote: Hi guys, I've installed potgres on a Ubuntu machine. Postgres version? Ubuntu version? How did you install Postgres and from where? When I start it, it doesn't start... Show the command you used to start it. /etc/init.d/postgresql status

[GENERAL] Postgresql 9.2 Ubuntu - is not starting

Hi guys, I've installed potgres on a Ubuntu machine. When I start it, it doesn't start... > /etc/init.d/postgresql status *●* postgresql.service - PostgreSQL RDBMS >Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor > preset: enabled) >Active: *active (exited)* sin

Re: [GENERAL] PostgreSQL GUI tools

Hi Subhan, Sorry for the quite late reply, but just in case you're still looking for a proper GUI - you may want to check out our latest Mac OS GUI for PostgreSQL at http://sequel.tech We're just about to release it and is probably the best Mac GUI for PostgreSQL now. Let me know if I can help w

Re: [GENERAL] PostgreSQL image for rkt on CoreOS

Though not an ACI image, CoreOS maintains a much smaller Docker image for PostgreSQL at https://quay.io/repository/coreos/postgres. Derek On 9 July 2016 at 10:29, Derek Mahar wrote: > Where may I find a PostgreSQL App Container Image (ACI) for rkt on > CoreOS? I understand that rkt can use the

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

Hi, On Wed, 2016-07-13 at 20:56 +, Steve Langlois wrote: > I've been searching for a 9.2.15 version of the postgresql script for "init > script for starting up the PostgreSQL". I have managed to find older versions > than what we are currently using, 8.2.5 but haven't had any luck finding a >

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

g *Subject:* Re: [GENERAL] postgresql "init script" for postgres 9.2.15 On 07/13/2016 01:56 PM, Steve Langlois wrote: Hi, I've been searching for a 9.2.15 version of the postgresql script for "init script for starting up the PostgreSQL". I have managed to find older versio

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

Steve Langlois writes: > Thank you but in our appliance, we are not running postgres as a service, we > are running it programatically with this script, call postmaster to start it > for instance instead of using the service framework. Is there an equivalent > in 9.x or does it now have to run

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

Please don't top-post. On Wed, Jul 13, 2016 at 5:35 PM, Steve Langlois wrote: > Thank you but in our appliance, we are not running postgres as a service, > we are running it programatically with this script, call postmaster to > start it for instance instead of using the service framework. Is th

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

aver Sent: Wednesday, July 13, 2016 5:11:24 PM To: Steve Langlois; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgresql "init script" for postgres 9.2.15 On 07/13/2016 01:56 PM, Steve Langlois wrote: > > Hi, I've been searching for a 9.2.15 version of the postgresq

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

On 07/13/2016 01:56 PM, Steve Langlois wrote: Hi, I've been searching for a 9.2.15 version of the postgresql script for "init script for starting up the PostgreSQL". I have managed to find older versions than what we are currently using, 8.2.5 but haven't had any luck finding a new version in th

[GENERAL] postgresql "init script" for postgres 9.2.15

Hi, I've been searching for a 9.2.15 version of the postgresql script for "init script for starting up the PostgreSQL". I have managed to find older versions than what we are currently using, 8.2.5 but haven't had any luck finding a new version in the postgres 9.2.15 rpms. We are moving from Ce

Re: [GENERAL] PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress

Peter Olivier writes: > I create a foreign table F1 on Database local which points to Remote.R1 > When updating F1 the trigger on Remote.R1 fires but gives the following > warning: > WARNING: there is no transaction in progress Seems odd, but I think you'll have to give a complete example for a

Re: [GENERAL] PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress

On 07/12/2016 02:39 AM, Peter Olivier wrote: Hi, I have the following setup: Database Local has a table L1 Database Remote has a table R1 and a table R2. Table Remote.R1 has a trigger. This trigger updates Remote.R2 I create a foreign table F1 on Database local which points to Remote.R

[GENERAL] PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress

Hi, I have the following setup: Database Local has a table L1 Database Remote has a table R1 and a table R2. Table Remote.R1 has a trigger. This trigger updates Remote.R2 I create a foreign table F1 on Database local which points to Remote.R1 When updating F1 the trigger on Remote.R1

[GENERAL] PostgreSQL image for rkt on CoreOS

Where may I find a PostgreSQL App Container Image (ACI) for rkt on CoreOS? I understand that rkt can use the official PostgreSQL Docker image available on Docker Hub, but it would be beneficial to also have an rkt-tested ACI image. Thank you, Derek

Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

ailto:adrian.kla...@aklaver.com] Sent: Thursday, June 30, 2016 7:47 PM To: Hanan Brener ; pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit) On 06/30/2016 09:24 AM, Hanan Brener wrote: Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; rub

Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit) On 06/30/2016 09:24 AM, Hanan Brener wrote: > Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8 How did you install the Postgres server? > > and get from > *https://pkgs.

Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

On 06/30/2016 09:24 AM, Hanan Brener wrote: Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8 How did you install the Postgres server? and get from *https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html* I would say where you install plruby from depend

Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

Hanan Brener writes: > Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8 > and get from > https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html > - plruby libraries(postgresql-plruby-0.5.3-4.el6.x86_64). > Additional installed postgresql95-libs > (postgresq

[GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8 and get from https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html - plruby libraries(postgresql-plruby-0.5.3-4.el6.x86_64). Additional installed postgresql95-libs (postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)

Re: [GENERAL] Postgresql-fdw

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] Postgresql-fdw

On Sun, May 22, 2016 at 23:38:43 -0700, John R Pierce wrote: If you want to use postgres to query this data efficiently, you really should import this data into postgres tables, properly indexed for the sorts of queries you wish to do. And it isn't that hard to script this kind of thing. P

Re: [GENERAL] postgresql embedded mode

On Mon, May 23, 2016 at 9:17 AM, Albe Laurenz wrote: > David G. Johnston wrote: > > On Mon, May 23, 2016 at 6:54 AM, aluka raju > wrote: > >> As given in the FAQ's that postgresql cannot be embedded > >> https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F . > >> > >> Is their any

Re: [GENERAL] postgresql embedded mode

On Mon, May 23, 2016 at 9:51 AM, Adrian Klaver wrote: > On 05/23/2016 03:54 AM, aluka raju wrote: > >> >> Hello, >> >> As given in the FAQ's that postgresql cannot be >> embedded >> https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F . >> >> Is their any possibility to make it embe

Re: [GENERAL] postgresql embedded mode

On 05/23/2016 03:54 AM, aluka raju wrote: Hello, As given in the FAQ's that postgresql cannot be embedded https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F . Is their any possibility to make it embedded. Till now postgresql has not done this embedded mode and i want to work on

Re: [GENERAL] postgresql embedded mode

On Monday, May 23, 2016 1:17:13 PM EDT Albe Laurenz wrote: > David G. Johnston wrote: > > > On Mon, May 23, 2016 at 6:54 AM, aluka raju > > wrote: > > >> As given in the FAQ's that postgresql cannot be embedded > >> https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F . > >> > >>

Re: [GENERAL] postgresql embedded mode

David G. Johnston wrote: > On Mon, May 23, 2016 at 6:54 AM, aluka raju wrote: >> As given in the FAQ's that postgresql cannot be embedded >> https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F . >> >> Is their any possibility to make it embedded. Till now postgresql has not >> don

Re: [GENERAL] postgresql embedded mode

On Mon, May 23, 2016 at 6:54 AM, aluka raju wrote: > > Hello, > > As given in the FAQ's that postgresql cannot be embedded > https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F . > > Is their any possibility to make it embedded. Till now postgresql has not > done this embedded mode

[GENERAL] postgresql embedded mode

Hello, As given in the FAQ's that postgresql cannot be embedded https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F . Is their any possibility to make it embedded. Till now postgresql has not done this embedded mode and i want to work on how it can be embedded and contribute. pleas

Re: [GENERAL] Postgresql-fdw

On 5/22/2016 10:52 PM, 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. I want to prepare an api for running sql queries for the data in files,so i am

Re: [GENERAL] Postgresql-fdw

You can build a multicorn fdw http://multicorn.org/ Regards On May 23, 2016 7:54 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. I want to pr

[GENERAL] Postgresql-fdw

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. I want to prepare an api for running sql queries for the data in files,so i am trying to have separate postgresql engine and

Re: [GENERAL] Postgresql-MongoDb foreigndata wrapper

Cc pg-list Pls avoiding reaching out to members via list. I may not know something which someone else in the list may know. On Mon, 23 May 2016, 1:22 p.m. aluka raju, wrote: > Hello, > > I have data storage in flat files (structured and unstructured) . I want > to run sql queries on that , so i

Re: [GENERAL] Postgresql-MongoDb foreigndata wrapper

On Mon, 23 May 2016, 1:03 p.m. aluka raju, wrote: > Hello, > > I want use my data source as mongodb and connect through postgresql fdw. > Is their any restrictions that the data present in mongodb to be structured > or unstructured data? > For connecting to mongoDB you would need mongodb_fdw an

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

On Sun, May 22, 2016 at 6:38 PM, Venkata Balaji N wrote: > > On Sun, May 22, 2016 at 1:59 AM, Tom Lane wrote: > >> Venkata Balaji N writes: >> > On Sat, May 21, 2016 at 1:04 AM, Tom Lane wrote: >> >> http://www.unix.com/man-page/opensolaris/3c/atomic_cas/ >> >> http://docs.oracle.com/cd/E23824

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

Hi Asif, Sorry, i should have responded first. Thanks for inputs and my replies are inline - > Any help would be appreciated. Do i need to give any particular CFLAGS ? >> >> >> Below is the *configure *command - >> >> >> ./configure --prefix=/opt/postgres/9.5.3 CC=/opt/SUNWspro/bin/cc >> 'CFLAGS

[GENERAL] Postgresql-MongoDb foreigndata wrapper

Hello, I want use my data source as mongodb and connect through postgresql fdw. Is their any restrictions that the data present in mongodb to be structured or unstructured data? Thanks aluka Sent with MailTrack

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

On Sun, May 22, 2016 at 1:59 AM, Tom Lane wrote: > Venkata Balaji N writes: > > On Sat, May 21, 2016 at 1:04 AM, Tom Lane wrote: > >> http://www.unix.com/man-page/opensolaris/3c/atomic_cas/ > >> http://docs.oracle.com/cd/E23824_01/html/821-1465/atomic-cas-3c.html > >> > >> I see that the first

Re: [GENERAL] PostgreSql Doubt

On 5/21/2016 2:22 PM, aluka raju wrote: I have a data source for example in file format(xml,csv ..etc) , i want to use postgresql engine to query select,update,insert using foreign data wrappers(fdw). updating/inserting into a CSV, XML, or whatever flat file will be very painful, it will re

Re: [GENERAL] PostgreSql Doubt

On 05/21/2016 02:22 PM, aluka raju wrote: Hello, I have a data source for example in file format(xml,csv ..etc) , i want to use postgresql engine to query select,update,insert using foreign data wrappers(fdw). question1 --- > is it possible to prepare our own fdw ?. http://www.postgresql.org/

[GENERAL] PostgreSql Doubt

Hello, I have a data source for example in file format(xml,csv ..etc) , i want to use postgresql engine to query select,update,insert using foreign data wrappers(fdw). question1 --- > is it possible to prepare our own fdw ?. question2 -> is it possible to seperate postgresql engine and use it

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

Venkata Balaji N writes: > On Sat, May 21, 2016 at 1:04 AM, Tom Lane wrote: >> http://www.unix.com/man-page/opensolaris/3c/atomic_cas/ >> http://docs.oracle.com/cd/E23824_01/html/821-1465/atomic-cas-3c.html >> >> I see that the first of those mentions it's for SunOS 5.11 whereas your >> machine

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

On Sat, May 21, 2016 at 1:04 AM, Tom Lane wrote: > Venkata Balaji N writes: > > "make" command is generating the following error while compiling > > postgresql-9.5.3 on Solaris SPARC. > > > Undefined first referenced > > symbol in file > > atomic

Re: [GENERAL] PostgreSql Doubts

On Fri, 20 May 2016 09:19:08 -0500, John McKown wrote: >I don't know much about FireBird. I (not a lawyer) think it has a very good >license. One interesting thing is that it says that it can run as a >"server", like PostgreSQL, or "embedded", like SQLite. But I can't really >figure out how the "

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

On Fri, May 20, 2016 at 11:04 AM, Tom Lane wrote: > src/include/port/atomics/generic-sunpro.h cites these references > as authority for believing that those functions exist in Solaris: > >http://www.unix.com/man-page/opensolaris/3c/atomic_cas/ >http://docs.oracle.com/cd/E23824_01/html/821-

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

Venkata Balaji N writes: > "make" command is generating the following error while compiling > postgresql-9.5.3 on Solaris SPARC. > Undefined first referenced > symbol in file > atomic_cas_64 port/atomics.o > atomic_cas_32

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

On Fri, May 20, 2016 at 10:38 AM, Jan de Visser wrote: > I would suggest reporting this on pgsql-hackers. I know some work was done on > the atomics over the last little while. If that's an issue (no sparc environment here), we're looking at b64d92f1 here that was new stuff in 9.5. -- Michael

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

On Friday, May 20, 2016 3:14:54 PM EDT Venkata Balaji N wrote: > Hi, > > "make" command is generating the following error while compiling > postgresql-9.5.3 on Solaris SPARC. > > I tried compiling 9.2 and 9.3, works fine. This is only happening on 9.5. ... snip ... > > Regards, > Venkata B N >

Re: [GENERAL] PostgreSql Doubts

On Fri, May 20, 2016 at 6:17 AM, aluka raju wrote: > Hello , > > 1) We are building an application where it needs a SQL engine to process > the data. We are evaluating whether to use postgreSQL along with the > foreign data wrappers. Can you please help us in letting know if postgreSQL > can be u

Re: [GENERAL] PostgreSql Doubts

On Fri, May 20, 2016 at 9:06 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, May 20, 2016 at 7:17 AM, aluka raju > wrote: > >> Hello , >> >> 1) We are building an application where it needs a SQL engine to process >> the data. We are evaluating whether to use postgreSQL along

Re: [GENERAL] PostgreSql Doubts

On Fri, May 20, 2016 at 7:17 AM, aluka raju wrote: > Hello , > > 1) We are building an application where it needs a SQL engine to process > the data. We are evaluating whether to use postgreSQL along with the > foreign data wrappers. Can you please help us in letting know if postgreSQL > can be u

[GENERAL] PostgreSql Doubts

Hello , 1) We are building an application where it needs a SQL engine to process the data. We are evaluating whether to use postgreSQL along with the foreign data wrappers. Can you please help us in letting know if postgreSQL can be used in embedded mode. 2) We want to have SQLEngine component al

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

Hi Venkata, I have't work on solaris sparc system since long but I would like to share my feedback on this, I hope it might be useful. On Fri, May 20, 2016 at 10:14 AM, Venkata Balaji N wrote: > Hi, > > "make" command is generating the following error while compiling > postgresql-9.5.3 on Solar

[GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

Hi, "make" command is generating the following error while compiling postgresql-9.5.3 on Solaris SPARC. I tried compiling 9.2 and 9.3, works fine. This is only happening on 9.5. ../../src/port/libpgport_srv.a ../../src/common/libpgcommon_srv.a -lnsl -lrt -lsocket -lm -o postgres Undefined

Re: [GENERAL] PostgreSQL with BDR - PANIC: could not create replication identifier checkpoint

El 19/05/16 a las 16:15, Cameron Smith escribió: > I'd agree: most likely a file system problem. Is there any hope that this > file could be re-built? > > My current plan is to use bdr_part_by_node_names to remove the failing node > and then rebuild it from a fresh backup (and probably on a ne

Re: [GENERAL] PostgreSQL with BDR - PANIC: could not create replication identifier checkpoint

Smith From: Alvaro Herrera Sent: May 19, 2016 2:56 PM To: Cameron Smith Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL with BDR - PANIC: could not create replication identifier checkpoint CAUTION EXTERNAL EMAIL Cameron Smith wrote:

Re: [GENERAL] PostgreSQL with BDR - PANIC: could not create replication identifier checkpoint

## Cameron Smith (csm...@stereodllc.com): > t:2016-05-19 01:14:51.668 UTC d= p=144 a=PANIC: could not create replication > identifier checkpoint "pg_logical/checkpoints/8-F3923F98.ckpt.tmp": Invalid > argument > t:2016-05-19 01:14:51.671 UTC d= p=9729 a=WARNING: could not create > relation-ca

Re: [GENERAL] PostgreSQL with BDR - PANIC: could not create replication identifier checkpoint

Cameron Smith wrote: > t:2016-05-19 01:14:51.668 UTC d= p=144 a=PANIC: could not create replication > identifier checkpoint "pg_logical/checkpoints/8-F3923F98.ckpt.tmp": Invalid > argument This line corresponds to the following code in BDR's 9.4.4 src/backend/replication/logical/replication_id

[GENERAL] PostgreSQL with BDR - PANIC: could not create replication identifier checkpoint

Hi PostgreSQL community: We have a three node postgresql BDR set up. One of our nodes went down due to a power issue. After bringing the server back online the OS reported the need to repair some files. Once this completed and we restarted the postgresql service, we noticed that it was cras

Re: [GENERAL] PostgreSQL and Windows 10 exception 0xC0000018

On 5/5/2016 1:17 PM, Moreno Andreo wrote: Il 05/05/2016 18:40, George Neuner ha scritto: Otherwise: if Postgresql is loading any non-standard extensions, I would try to check those DLLs. If you have a recent Visual Studio handy, run "link /dump /headers " on the DLLs and look for any that say "

Re: [GENERAL] PostgreSQL and Windows 10 exception 0xC0000018

Disclaimer: I do not run Postgresql on Windows. On Thu, 5 May 2016 14:39:25 +0200, Moreno Andreo wrote: >a strange error is happening to some of our customers. >They all have a Windows 10 installation on their machines with >our application and, of course, PostgreSQL 9.1 installed >(migrat

[GENERAL] PostgreSQL and Windows 10 exception 0xC0000018

Hi all,     a strange error is happening to some of our customers. They all have a Windows 10 installation on their machines with our application and, of course, PostgreSQL 9.1 installed (migration to 9.5 upcoming in late summer/fall, but not applicable by now) W

Re: [GENERAL] postgresql & Fulltext & ranking & my own functions

Thanks Oleg, this is a good start for me 2016-05-03 15:47 GMT+02:00 Oleg Bartunov : > > > On Tue, May 3, 2016 at 3:21 PM, Nicolas Paris wrote: > >> Hello, >> >> Documentation says : ( >> http://www.postgresql.org/docs/9.5/static/textsearch-controls.html#TEXTSEARCH-RANKING >> ) >> "The built-in r

Re: [GENERAL] postgresql & Fulltext & ranking & my own functions

On Tue, May 3, 2016 at 3:21 PM, Nicolas Paris wrote: > Hello, > > Documentation says : ( > http://www.postgresql.org/docs/9.5/static/textsearch-controls.html#TEXTSEARCH-RANKING > ) > "The built-in ranking functions are only examples. You can write your own > ranking functions and/or combine their

[GENERAL] postgresql & Fulltext & ranking & my own functions

Hello, Documentation says : ( http://www.postgresql.org/docs/9.5/static/textsearch-controls.html#TEXTSEARCH-RANKING ) "The built-in ranking functions are only examples. You can write your own ranking functions and/or combine their results with additional factors to fit your specific needs." The b

[GENERAL] PostgreSQL proxying

Hello folks! :-) hope I'm not OT here Need an advise here. I have a PostgreSQL cluster that should be accessed in two ways: - By a Web Services system (always same host in my vLAN, and that is simple) - By a replicator (any host, with unpredictable IP) In my previous configuration I had a VP

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

* Albe Laurenz (laurenz.a...@wien.gv.at) wrote: > Marllius wrote: > > OCFS2 = oracle cluster file system 2 > > I think using OCFS2 for PostgreSQL data is a good idea if you want > to be the first at something or try to discover bugs in OCFS2. I've found that OCFS2 is a very decent clustered files

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

Thanks guys, the answers helped me a lot in my decision , I'm evaluating my options.

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

On 4/8/2016 6:16 AM, Marllius wrote: thank you, but i need a link in official postgresql documentation as postgresql is operating system independent, its pretty unlikely there will be discussions of specific file systems in the official documentation. -- john r pierce, recycling bits in s

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

Marllius wrote: > OCFS2 = oracle cluster file system 2 I think using OCFS2 for PostgreSQL data is a good idea if you want to be the first at something or try to discover bugs in OCFS2. Why do you want a cluster file system for PostgreSQL? You cannot have more than one server access the same data

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

On 4/8/2016 7:20 AM, Scott Mead wrote: I'm not sure if that link exists, the general rule is In g if it's POSIX, it'll work. You'll find that most PostgreSQL-ers have strong opinions and preferences in regards to filesystems. Personally, I know that XFS will work, it's not *my* preference,

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

On Fri, Apr 8, 2016 at 9:16 AM, Marllius wrote: > thank you, but i need a link in official postgresql documentation > I'm not sure if that link exists, the general rule is In g if it's POSIX, it'll work. You'll find that most PostgreSQL-ers have strong opinions and preferences in regards to file

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

thank you, but i need a link in official postgresql documentation OCFS2 = oracle cluster file system 2 2016-04-08 10:00 GMT-03:00 Bob Lunney : > XFS absolutely does. Its well supported on Redhat and CentOS 6.x and > 7.x. Highly recommended. > > Don’t know about OCFS2. > > Bob Lunney > Lead Dat

<    1   2   3   4   5   6   7   8   9   10   >