Re: One way replication in PostgreSQL

2019-06-04 Thread Frank Alberto Rodriguez
The FDW is a PostgreSQL extension to connect to other server from PosgreSQL server inside, with this solution you only need connections from P to S and no need a third server (external server), just use triggers to push the INSERT/UPDATE/DELETE information you want to replicate from P to S through

Re: One way replication in PostgreSQL

2019-06-03 Thread Frank Alberto Rodriguez
You could use FDW to replicate what you need to an external server from the provider/primary/master to the subscriber/secondary/slaveUsing triggers on the master tables that you want to replicate, you can execute the insert/update/delete actions on the secondary tables through the FDW.With this app

Re: Data entry / data editing tools (more end-user focus).

2019-05-23 Thread Frank Alberto Rodriguez
If you have the database modeled, the most quickly think I can thinks is with python framework Django. Configure the connection to the DB and make reverse engineer with Django, this create the entities class, then activate the administration forms and configure each form for the entities (few line

Re: PITR based recovery in a primary/standby cluster setup

2019-05-21 Thread Frank Alberto Rodriguez
Hello.I'm not sure which replications issues you have, and I never used Wall-E before, but I get some issues with PotgreSql 10 and Barman. Try starting the primary server at first, when it finish to recovery this should start as primary, if not then go to the postgresql data directory and rename th

Re: duplicate key value violates unique constraint "chinese_price_infos_pkey"

2019-05-07 Thread Frank Alberto Rodriguez
You can fix the problem with this query: SELECT setval('chinese_price_infos_id_seq', sq.val) from ( SELECT MAX(id) as val FROM chinese_price_infos ) sq; But you have to search in your application because in some point the app are inserting the id column instead of leave this task to the DB. If y

Re: Forks of pgadmin3?

2019-03-22 Thread Frank Alberto Rodriguez Solana
You could try OmniDB, is web app but have a version that just feels like a desktop application. Is supported by 2ndQuadrant. This is the official website https://omnidb.org/en/ Greetings El vie., 22 mar. 2019 a las 4:56, Christian Henz () escribió: > I know I'm late to the party, but we're onl