Re: using graph model with PostgreSQL

2018-08-17 Thread 김세훈
Thanks guys, I appreciate your answers. 2018-08-17 1:10 GMT+09:00 Data Ace : > I think's its a forked PostgreSQL, try AgensGraph: > > https://www.postgresql.org/download/products/8/ > > On Wed, Aug 15, 2018 at 7:09 AM, 김세훈 wrote: > >> Hi there, >> >> currently I'm using PostgreSQL with PostGIS

Re: vPgSql

2018-08-17 Thread Tim Cross
Vlad ABC writes: > On Fri, 2018-08-17 at 15:45 +0300, Dmitry Igrishin wrote: >> >> Looking nice! Thank you. But I unable to start it on Ubuntu, because >> there is no bash(1) in /usr/bin. > > Thank you, i'll fix it. > I think pretty much all *nix systems put core shells like sh, bash, zsh etc

Re: vPgSql

2018-08-17 Thread Vlad ABC
On Fri, 2018-08-17 at 15:45 +0300, Dmitry Igrishin wrote: > > Looking nice! Thank you. But I unable to start it on Ubuntu, because > there is no bash(1) in /usr/bin. Thank you, i'll fix it. > Also, it is open source? No, it is freeware

Re: vPgSql

2018-08-17 Thread Dmitry Igrishin
пт, 17 авг. 2018 г. в 21:19, Joshua D. Drake : > > On 08/17/2018 05:45 AM, Dmitry Igrishin wrote: > > Hey Vlad > > пт, 17 авг. 2018 г. в 15:31, Vlad Alexeenkov : > >> Maybe will be useful for someone > >> > >> Very simple Postgres SQL client vPgSql: > >> > >> https://vsdev.ru > > Looking nice! Than

Re: vPgSql

2018-08-17 Thread Joshua D. Drake
On 08/17/2018 05:45 AM, Dmitry Igrishin wrote: Hey Vlad пт, 17 авг. 2018 г. в 15:31, Vlad Alexeenkov : Maybe will be useful for someone Very simple Postgres SQL client vPgSql: https://vsdev.ru Looking nice! Thank you. But I unable to start it on Ubuntu, because there is no bash(1) in /usr/bin

including header files in a C extension

2018-08-17 Thread TalGloz
Hi, If I have an external library that I install using make install into the /usr/local/include/libraryname path by default and I want to include it in a C extension, the Makefile for the .so file includes the headers in /usr/local/include/libraryname path. Can I use #include when writing C/CPP

Re: pg_stat_activity.query_start in the future?

2018-08-17 Thread Adrian Klaver
On 08/17/2018 09:11 AM, Justin Pryzby wrote: I'm buried and not having any good ideas how to diagnose this or what else to send, so here it is. Feel free to tell me why I'm the one whose confused.. postgres=# SELECT pid, now(), query_start, state, query FROM pg_stat_activity WHERE pid=27757;

pg_stat_activity.query_start in the future?

2018-08-17 Thread Justin Pryzby
I'm buried and not having any good ideas how to diagnose this or what else to send, so here it is. Feel free to tell me why I'm the one whose confused.. postgres=# SELECT pid, now(), query_start, state, query FROM pg_stat_activity WHERE pid=27757; pid | now |

Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?

2018-08-17 Thread Adrian Klaver
On 08/16/2018 09:42 PM, Raghavendra Rao J S V wrote: Thank you very much for your response. Could you clarify me below things,please? The docs can: https://www.postgresql.org/docs/10/static/routine-vacuuming.html#AUTOVACUUM https://www.postgresql.org/docs/10/static/runtime-config-autovacuum.

Error installing postgresql 9.5.14 on windows7: “unable to write inside temp environment variable path”

2018-08-17 Thread abhinav srivastava
Hi, I have already tried what have been suggested online but nothing worked.I tried this solution:https://www.youtube.com/watch?v=h6HRGFJvzzw I also tried to enable WSH via http://1stopit.blogspot.com/2011/01/postgresql-83-and-84-fails-to-install.html but all this did not solve the problem, sti

Re: vPgSql

2018-08-17 Thread Johnes Castro
Nice, Very useful. De: Vlad Alexeenkov Enviado: sexta-feira, 17 de agosto de 2018 10:30 Para: pgsql-general@lists.postgresql.org Assunto: vPgSql Maybe will be useful for someone Very simple Postgres SQL client vPgSql: https://vsdev.ru Gogs - Very simple Post

Re: vPgSql

2018-08-17 Thread Dmitry Igrishin
Hey Vlad пт, 17 авг. 2018 г. в 15:31, Vlad Alexeenkov : > > Maybe will be useful for someone > > Very simple Postgres SQL client vPgSql: > > https://vsdev.ru Looking nice! Thank you. But I unable to start it on Ubuntu, because there is no bash(1) in /usr/bin. Also, it is open source?

Re: pg_upgrade (and recovery) pitfalls

2018-08-17 Thread Stephen Frost
Greetings, * PO (gunnar.bl...@pro-open.de) wrote: > Stephen Frost – Thu, 16. August 2018 19:00 > > * PO (gunnar.bl...@pro-open.de) wrote: > > > - why does a recovery, based on a recovery.conf that points to a reachable > > primary (which obviously communicates its own timeline), still look for >

vPgSql

2018-08-17 Thread Vlad Alexeenkov
Maybe will be useful for someone Very simple Postgres SQL client vPgSql: https://vsdev.ru Best regards, Vlad Alexeenkov

Re: pg_upgrade (and recovery) pitfalls

2018-08-17 Thread PO
Stephen Frost – Thu, 16. August 2018 19:00 > Greetings, I salute you, Stephen! TL;DR: I blundered by not spotting an easter egg of my predecessors. > * PO (gunnar.bl...@pro-open.de) wrote: > > Consider the following scenario/setup: > > - 4 DB servers in 2 DCs > > - 1 primary (in DC1) > > - 1 sy