Re: [GENERAL] cluster question

Hi Quick question. I have a 2 node cluster - each node has its own ip. But from reading this, I really need a 3rd ip, which potentially floats between the nodes to which ever is the master / rw node. Is that right? Sort of makes sense I guess A On 14 August 2017 at 16:47, Andreas Kretschmer

Re: [GENERAL] WAL replication wrong collate

On Tue, Aug 15, 2017 at 3:52 AM, basti wrote: > master and slave had set the same locales. > I dont unterstand that i can create a database in en_us.utf8 and then when i > did the basebackup it's change to c locale. > I cant find any option for pg_basebackup to set

Re: [GENERAL] Queries for Diagramming Schema Keys

On Mon, Aug 14, 2017 at 6:38 PM, wrote: > ... > > Just to add that running psql with the -E switch is REALLY handy for > seeing how psql executes queries to > > find how tables etc are put together. > > I can't actually use that feature to gather the information I'm

Re: [GENERAL] Queries for Diagramming Schema Keys

... > Just to add that running psql with the -E switch is REALLY handy for seeing > how psql executes queries to > find how tables etc are put together. I can't actually use that feature to gather the information I'm interested in since all I have are tables and data with no formal

Re: [GENERAL] Queries for Diagramming Schema Keys

...snip... For all tables and columns I get no output at all. Basically I need all tables and columns for which the column is neither a regular primary key, nor a foreign key. This will be marked as an attribute in the diagramming program. Your query for primary keys which are not foreign keys

Re: [GENERAL] Queries for Diagramming Schema Keys

Just to add that running psql with the -E switch is REALLY handy for seeing how psql executes queries to find how tables etc are put together.

Re: [GENERAL] Queries for Diagramming Schema Keys

On Mon, Aug 14, 2017 at 2:46 PM, wrote: > Hi, > > I'm trying to write an application (using libpqxx/C++) which creates > graphical images of large and complex relations between tables (basically > an SVG image with hot spots for drilling down on details). I need to >

[GENERAL] WAL replication wrong collate

Hello, i try to replicate my database. what i have done? - create a cluster on slave (UTF8, en_US.utf8 collate/c_type) - stop cluster and cleanup datadir - do basebackup from master - start db-cluster Master has utf8, en_us.uft8 collate/c_type Now my db on slave has UTF8, c.utf8

[GENERAL] Queries for Diagramming Schema Keys

Hi, I'm trying to write an application (using libpqxx/C++) which creates graphical images of large and complex relations between tables (basically an SVG image with hot spots for drilling down on details). I need to essentially create icons of tables and their columns, and then draw

Re: [GENERAL] Development of an extension for PostgreSQL and PostGIS

In order to get an LWGEOM from PostGIS you'll need to convert from the serialized form (GSERIALIZED) which you can read all about in the liblwgeom.h header. You'll be adding a hard dependency of course, but hopefully you're OK with that. If you're just hoping to build a compound type, as your

[GENERAL] Development of an extension for PostgreSQL and PostGIS

Hello. I will start developing an extension to PostgreSQL next to PostGIS using the C language. If my new type were: CREATE TYPE mytype (.., .., .., geom geometry); The creation of the structure in c, would be something like? #include "liblwgeom.h" Struct mytype { Int32 id; LWGEOM

[GENERAL] PostgreSQL used in our network engine (SLikeNet)

Hi, I'd just like to quickly reach out to let you know that we released a new (open source) network engine in which we also utilize PostgreSQL and want to thank you for the work you put into the project. PostgreSQL is utilized for two parts in the network engine: - as an option for a backend db

Re: [GENERAL] Adding a new Clause in the Source Code

On 8/14/17 04:14, Stefan Wagner wrote: > I would really appreciate if someone could hack me a quick example of a > new clause lets call it ADDITIONAL with Keywords HIGH, LOW to order > columns. I just want the construct. What > the Keywords accomplish and the Algorithm is something I'm gonna try

[GENERAL] Adding a new Clause in the Source Code

Recently I started to take a look at Postgresql on the Source Level. I wanted to extend the Parser by a simple Clause which isn't as easy as I expected. Hence I'm here asking for help. This might seem trivial for a Person which is able to answer this Question but please take a moment of your time

Re: [GENERAL] Where is pg_hba.conf

Hello, On Sun, Aug 13, 2017 at 10:00:23AM -0400, Igor Korot wrote: > However, I can't find this file anywhere on the system. > I am able to connec to the server locally with psql. I can also > connect to the server > from the ODBC driver from my program. However doing a global search I > can't

Re: [GENERAL] cluster question

On 14 August 2017 08:39:54 GMT+02:00, Alex Samad wrote: >Hi > >I have setup a streaming replicating cluster, with a hot standby. > >Now I would like to change the RW to hot standby and change the hot >standby >to be the RW server. > >Is it just a matter of updating recover.conf

[GENERAL] cluster question

Hi I have setup a streaming replicating cluster, with a hot standby. Now I would like to change the RW to hot standby and change the hot standby to be the RW server. Is it just a matter of updating recover.conf file ? Alex