Re: [GENERAL] How to continue streaming replication after this error?

On 21/02/14 09:17, Torsten Förtsch wrote: > one of our streaming replicas died with > > 2014-02-21 05:17:10 UTC PANIC: heap2_redo: unknown op code 32 > 2014-02-21 05:17:10 UTC CONTEXT: xlog redo UNKNOWN > 2014-02-21 05:17:11 UTC LOG: startup process (PID 1060) was terminated > by signal 6: Abor

[GENERAL] Why does PostgreSQL ftruncate before unlink?

When dropping lots of tables, I noticed postgresql taking longer than I would have expected. strace seems to report that the largest contributor is the ftruncate and not the unlink. I'm curious what the logic is behind using ftruncate before unlink. I'm using an ext4 filesystem. -- Jon -- Se

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

Thought I might add, now that I've had more time to work with it, that adding the PostgreSQL host to the domain isn't necessary, and at least with Samba 3 is a huge waste of time thanks to the machine password changing policies in Active Directory. Much better to create an ordinary user account wi

Re: [GENERAL] problem with query and group by error

Susan Cassidy-3 wrote > Someone said something about > "Yes, except those that are inside the aggregate." > but I don't have an aggregate specified. So every column then... As soon as you add "group by" the rule becomes - every column is either a group determinate or is aggregated. If you simpl

Re: [GENERAL] problem with query and group by error

I tried distinct on srs.scan_run_id, which is a primary key, and got an error, but I tried it again just now, and it worked fine. Thanks for having me try it again. I had ended up with group by srs.scan_run_id, sty.scan_type, ssn.scan_system_name, ssn.simulation, ssitenames.scan_site_name,

Re: [GENERAL] problem with query and group by error

On Fri, Feb 21, 2014 at 10:40 AM, Susan Cassidy wrote: > > I originally had the query without the group by, but I had duplicate rows, > so I added a group by to eliminate them. Have you tried select distinct or select distinct on ()? -- Sent via pgsql-general mailing list (pgsql-general@postg

Re: [GENERAL] problem with query and group by error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 El 21/02/14 14:40, Susan Cassidy escribió: > I have a large query: SELECT distinct on (srs.scan_run_id) > srs.scan_run_id, srs.run_request_number, srs.container_id, > srs.manifest_id, srs.scan_system_name_id, srs.scan_site_name_id, > srs.scan_site_

Re: [GENERAL] problem with query and group by error

Susan Cassidy-3 wrote > I have a large query: >SELECT distinct on (srs.scan_run_id) srs.scan_run_id, > srs.run_request_number, srs.container_id, srs.manifest_id, > srs.scan_system_name_id, >srs.scan_site_name_id, srs.scan_site_nickname_id, > to_char(srs.start_time, 'MM/DD/YY HH24:MI:SS'

[GENERAL] problem with query and group by error

I have a large query: SELECT distinct on (srs.scan_run_id) srs.scan_run_id, srs.run_request_number, srs.container_id, srs.manifest_id, srs.scan_system_name_id, srs.scan_site_name_id, srs.scan_site_nickname_id, to_char(srs.start_time, 'MM/DD/YY HH24:MI:SS'), to_char(srs.stop_time, '

Re: [GENERAL] semi-variable length type

James Harper writes: >> regression=# create table t1 (f1 float(5), f2 float(30)); >> CREATE TABLE >> regression=# \d t1 >> Table "public.t1" >> Column | Type | Modifiers >> +--+--- >> f1 | real | >> f2 | double precision | >> >> Othe

[GENERAL] Read tables of sql server with postgres

I'm trying to access sql server tables through postgres, I tried using this wrapper for databases with this ODBC driver , but the lastest version is compatible only with the

[GENERAL] How to continue streaming replication after this error?

Hi, one of our streaming replicas died with 2014-02-21 05:17:10 UTC PANIC: heap2_redo: unknown op code 32 2014-02-21 05:17:10 UTC CONTEXT: xlog redo UNKNOWN 2014-02-21 05:17:11 UTC LOG: startup process (PID 1060) was terminated by signal 6: Aborted 2014-02-21 05:17:11 UTC LOG: terminating any