Re: [GENERAL] Recovery damaged dump file

On 03/09/2017 09:09 PM, Adrian Klaver wrote: On 03/09/2017 03:55 AM, mac pack wrote: Hi. My PostgreSQL server was affect by a Ransomware virus. I'm trying to restore the database from a dump file made by pg_dump in custom format (-F c option), but the dump file seems to be damaged in the

Re: [GENERAL] Recovery damaged dump file

On 03/09/2017 03:55 AM, mac pack wrote: Hi. My PostgreSQL server was affect by a Ransomware virus. I'm trying to restore the database from a dump file made by pg_dump in custom format (-F c option), but the dump file seems to be damaged in the first's 1000 lines. Opening the file with vi shows

Re: [GENERAL] Unable to start postgresql

On Thursday 09 March 2017 16:37:28 you wrote: > On 03/08/2017 10:12 AM, John Iliffe wrote: > > I think you may have hit it but I'm even more confused now. > > > > I looked at the running Postgesql on the current server and there is a > > 5th sub-directory called /data. That is on the same level

Re: [GENERAL] Removing and readding bdr nodes

Sorry for the paleo post but curious if there was ever a resolution for this issue regarding BDR member join/eject: https://goo.gl/N7FoUB I'm currently seeing very similar behavior for the latest version of BDR where cluster nodes are very confused about the state of their

Re: [GENERAL] Recovery damaged dump file

On Thu, Mar 9, 2017 at 8:55 PM, mac pack wrote: > pg_restore db.backup > out.sql > > pg_restore: [custom archiver] unrecognized data block type (0) while > searching archive > > The follow commands works fine: > pg_restore -s db.backup > out.sql > pg_restore -l db.backup If

Re: [GENERAL] Unable to start postgresql

On 03/08/2017 10:12 AM, John Iliffe wrote: I think you may have hit it but I'm even more confused now. I looked at the running Postgesql on the current server and there is a 5th sub-directory called /data. That is on the same level as the /bin, /share, etc. In this new installation it is not

Re: [GENERAL] count case when - PG 9.2

2017-03-10 10:17 GMT+13:00 Yasin Sari : > if you want see account_status and the count()- try this: > > SELECT > > CASE > > WHEN AND c.regdate > EXTRACT(epoch FROM (now() - INTERVAL '14 > day')) > > THEN 'trial' > > WHEN last_pay > EXTRACT(epoch

Re: [GENERAL] Unable to start postgresql

On 03/08/2017 10:12 AM, John Iliffe wrote: I think you may have hit it but I'm even more confused now. I looked at the running Postgesql on the current server and there is a 5th sub-directory called /data. That is on the same level as the /bin, /share, etc. In this new installation it is not

Re: [GENERAL] count case when - PG 9.2

On Thu, Mar 9, 2017 at 2:01 PM, Patrick B wrote: > > Could you please guys give me a query as an example? > > ​Maybe if you describe exactly how you want the output to appear. And maybe tee things up by writing a query that gets close and with some example data.

Re: [GENERAL] count case when - PG 9.2

2017-03-09 23:15 GMT+13:00 vinny : > On 2017-03-09 05:27, Patrick B wrote: > >> Hi guys. How can I count using 'CASE WHEN'? >> >> Example: >> >> SELECT >>> >>> CASE >>> >>> WHEN AND c.regdate > EXTRACT(epoch FROM (now() - INTERVAL '14 day')) >>> >>> THEN

Re: [GENERAL] PGSQL 9.6.2 unable to find readline

On Tuesday, March 7, 2017 3:35 PM, John Iliffe wrote:   >  > Trying to compile pgsql 9.6.2 on Fedora 25  >  > I get the following message:  >  > configure:9345: error: readline library not found  > If you have readline already installed, see config.log for details

Re: [GENERAL] Feature request - psql --quote-variable

Thank you. Apparently I never saw this response, for some reason... So reading that leaves me confused on one point, which is the right way to do it if you're inserting an integer? would this be right? is there a difference between the single and double quotes here? (presume id is a bigint)

Re: [GENERAL] Copy database to another host without data from specific tables

Thanks for the replies, pg_dump —exclude-table will do for now. Panagiotis (atmosx) Atmatzidis email: a...@convalesco.org URL:http://www.convalesco.org GnuPG ID: 0x1A7BFEC5 gpg --keyserver pgp.mit.edu --recv-keys 1A7BFEC5 "Everyone thinks of changing the world, but no one thinks of

Re: [GENERAL] Unable to start postgresql

I think you may have hit it but I'm even more confused now. I looked at the running Postgesql on the current server and there is a 5th sub-directory called /data. That is on the same level as the /bin, /share, etc. In this new installation it is not present and neither is the postgresql.conf

[GENERAL] Recovery damaged dump file

Hi. My PostgreSQL server was affect by a Ransomware virus. I'm trying to restore the database from a dump file made by pg_dump in custom format (-F c option), but the dump file seems to be damaged in the first's 1000 lines. Opening the file with vi shows ^@^@^@^@^@^@^@^@^@^@^ followed by part of

[GENERAL] Help regarding flushing data from Shared Memory to Database

Hi, We are currently working on cstore extension. We are storing the all the inserts in a shared memory and then flushing the tuples to the database. We are using a background worker to periodically flush the data. But the problem is we are not able to do the insert the data during the periodic

Re: [GENERAL] Unable to start postgresql

On 03/09/2017 08:14 AM, John Iliffe wrote: On Thursday 09 March 2017 09:17:51 Adrian Klaver wrote: On 03/08/2017 09:28 PM, Tom Lane wrote: John Iliffe writes: Comparing my results with Adrian's example, I notice that we both have the Unix domain socket 5432 running

Re: [GENERAL] Unable to start postgresql

On Thursday 09 March 2017 12:49:49 Tom Lane wrote: > John Iliffe writes: > > On Thursday 09 March 2017 12:08:01 Tom Lane wrote: > >> AFAICS, the explanation must be that getaddrinfo() returned two IPv4 > >> addresses, one of which got bound successfully and the other not. >

Re: [GENERAL] Unable to start postgresql

John Iliffe writes: > On Thursday 09 March 2017 12:08:01 Tom Lane wrote: >> AFAICS, the explanation must be that getaddrinfo() returned two IPv4 >> addresses, one of which got bound successfully and the other not. >> The bleat is about the non-working address, but you still

Re: [GENERAL] Unable to start postgresql

On Thursday 09 March 2017 12:08:01 Tom Lane wrote: > John Iliffe writes: > > Here is my matching ss output > > > > -- > > [root@prod04 John]# ss -l -p | grep post > > u_str LISTEN 0 128/tmp/.s.PGSQL.5432 69422 > > *

Re: [GENERAL] Unable to start postgresql

John Iliffe writes: > Here is my matching ss output > -- > [root@prod04 John]# ss -l -p | grep post > u_str LISTEN 0 128/tmp/.s.PGSQL.5432 69422 * > 0 users:(("postgres",pid=2760,fd=5)) > tcp

Re: [GENERAL] Unable to start postgresql

On Thursday 09 March 2017 09:17:51 Adrian Klaver wrote: > On 03/08/2017 09:28 PM, Tom Lane wrote: > > John Iliffe writes: > >> On Wednesday 08 March 2017 23:35:10 Tom Lane wrote: > >>> That isn't proving a lot: as I showed in my example lsof output, > >>> Fedora's lsof will

Re: [GENERAL] Unable to start postgresql

On 03/08/2017 09:28 PM, Tom Lane wrote: > John Iliffe writes: >> On Wednesday 08 March 2017 23:35:10 Tom Lane wrote: >>> That isn't proving a lot: as I showed in my example lsof output, >>> Fedora's lsof will map "5432" to "postgres" in the context of an IP >>> port number.

[GENERAL] Help regarding flushing data from Shared Memory to Database

Hi, We are currently working on cstore extension. We are storing the all the inserts in a shared memory and then flushing the tuples to the database. We are using a background worker to periodically flush the data. But the problem is we are not able to do the insert the data during the periodic

Re: [GENERAL] count case when - PG 9.2

On 2017-03-09 05:27, Patrick B wrote: Hi guys. How can I count using 'CASE WHEN'? Example: SELECT CASE WHEN AND c.regdate > EXTRACT(epoch FROM (now() - INTERVAL '14 day')) THEN 'trial' WHEN last_pay > EXTRACT(epoch FROM (now() - INTERVAL '37 day')) THEN 'paying' END as