[GENERAL] Issue during postgresql startup

Dear All, Thanks for your support. Could you please tell me, how to recover my system. I am facing below errors. --- could not open relation 1663/16385/1299988: No such file or directory --- This message is continuous occurred in system . I have

Re: [GENERAL] Issue during postgresql startup

On 4/28/2016 12:21 AM, Yogesh Sharma wrote: Could you please tell me, how to recover my system. I am facing below errors. --- could not open relation 1663/16385/1299988: No such file or directory --- This message is continuous occurred in system .

Re: [GENERAL] Issue during postgresql startup

On Thu, 28 Apr 2016 15:22 Yogesh Sharma, wrote: > Dear All, > > Thanks for your support. > > Could you please tell me, how to recover my system. > > I am facing below errors. > --- > could not open relation 1663/16385/1299988: No such file or directory > --

Re: [GENERAL] Issue during postgresql startup

On 28/04/2016 10:21, Yogesh Sharma wrote: Dear All, Thanks for your support. Could you please tell me, how to recover my system. I am facing below errors. --- could not open relation 1663/16385/1299988: No such file or directory --- This message

Re: [GENERAL] Issue during postgresql startup

Dear Sameer and all, >Looks like someone has been playing around with the database files or some >disk issue. >Basically Postgres stores each table inside >$tablespace_dir/$database_dir/table_file >In this error it seems one of the files have been removed/lost Yes, I am suspecting a disk error o

Re: [GENERAL] Issue during postgresql startup

Dear John, >did you get that 'no such file or directory' error before or after you reset >the transaction logs ? The error message is coming before. >messing with the write-ahead logs is very dangerous. that blog is talking >about postgres 8.4, based on his paths. is that what you're running

Re: [GENERAL] Issue during postgresql startup

On 4/28/2016 1:33 AM, Yogesh Sharma wrote: >did you get that 'no such file or directory' error before or after you reset the transaction logs ? The error message is coming before. that means your file system lost files.there's a number of ways that can happen, mostly revolving around

Re: [GENERAL] Issue during postgresql startup

Dear John, >do you have backups from before this occurred ? No, there is no backup available for the same. Regards, Yogesh From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, April 28, 2016 2:18 PM To: pgsql-general@post

Re: [GENERAL] Issue during postgresql startup

On 4/28/2016 1:54 AM, Yogesh Sharma wrote: >do you have backups from before this occurred ? No, there is no backup available for the same. oops. it is possible some of your tables can be recovered by someone highly experienced in postgres data recovery. such people work for the various

Re: [GENERAL] psql color hostname prompt

Hi Steve: On Wed, Apr 27, 2016 at 7:09 PM, Steve Crawford wrote: > The various hacks appear to not deal with the fact that there may be > multiple instances of postgresql running on different TCP ports or Unix > connections nor with the fact that the local connection may, in fact, be a > pooler a

[GENERAL] xml-file as foreign table?

I have several large (7GB+) xml files to get into an SQL database. The xml-files can contain up to 500 000 subrecords which I want to be able to query in the database. They are too large to do something like this: insert into rawxml (xml) select XMLPARSE (DOCUMENT CONVERT_FROM(PG_READ_BINARY_FI

Re: [GENERAL] Does this perf output seem 'normal'?

On 28.04.2016 1:11, Peter Devoy wrote: I have now done a recording for 60 seconds during a batch of 1000 requests and posted the results on a new issue on the Mapnik repo. Although Postgres still comes out on top in the perf results I struggle to believe this is a Postgres issue. But, if anyo

Re: [GENERAL] CREATE EXTENSION without superuser access

On 04/27/2016 10:22 PM, Steve Atkins wrote: > Is there any way to install an extension either from a SQL connection or from > a user-defined directory instead of .../extensions? > > (And if not, is there a TODO here?) There is actually a TODON'T here. Search the pgsql-hackers archives for some v

Re: [GENERAL] Slow join over three tables

On 28 April 2016 at 08:36, Tim van der Linden wrote: > On Wed, 27 Apr 2016 13:48:06 +0200 > Alban Hertroys wrote: > >> In this case, you're using the values in adverse to filter relevant rid's >> for the FK join, so you might be better off with the inverse of above index: >> create index o

Re: [GENERAL] Does this perf output seem 'normal'?

>Also do you know that in perf report second column is the total cpu time >share and not the first Thank you, I did notice they did not add up -- that makes more sense now. >Can you expand node from perf report Yes, my pleasure. I added "--call-graph fractal,2,callee" to the command, hopefully

Re: [GENERAL] CREATE EXTENSION without superuser access

> On Apr 28, 2016, at 6:44 AM, Vik Fearing wrote: > > On 04/27/2016 10:22 PM, Steve Atkins wrote: >> Is there any way to install an extension either from a SQL connection or >> from a user-defined directory instead of .../extensions? >> >> (And if not, is there a TODO here?) > > There is actu

[GENERAL] "Keyed" sequence?

This is probably crazy talk, but in Postgresql is there any way to have a "keyed" sequence? That is, I have a table with a list of departments. While *relatively* static, technically speaking this is a dynamic list - someone certainly could decide to add a department, or combine two departments int

Re: [GENERAL] "Keyed" sequence?

On 04/28/2016 08:30 PM, Israel Brewster wrote: > This is probably crazy talk, but in Postgresql is there any way to have > a "keyed" sequence? That is, I have a table with a list of departments. > While *relatively* static, technically speaking this is a dynamic list - > someone certainly could dec

Re: [GENERAL] "Keyed" sequence?

> > On Apr 28, 2016, at 10:39 AM, Vik Fearing wrote: > > On 04/28/2016 08:30 PM, Israel Brewster wrote: >> This is probably crazy talk, but in Postgresql is there any way to have >> a "keyed" sequence? That is, I have a table with a list of departments. >> While *relatively* static, technically

Re: [GENERAL] "Keyed" sequence?

On 04/28/2016 11:48 AM, Israel Brewster wrote: On Apr 28, 2016, at 10:39 AM, Vik Fearing wrote: On 04/28/2016 08:30 PM, Israel Brewster wrote: This is probably crazy talk, but in Postgresql is there any way to have a "keyed" sequence? That is, I have a table with a list of departments. While

Re: [GENERAL] "Keyed" sequence?

On Thu, Apr 28, 2016 at 1:48 PM, Israel Brewster wrote: > > > > On Apr 28, 2016, at 10:39 AM, Vik Fearing wrote: > > > > On 04/28/2016 08:30 PM, Israel Brewster wrote: > >> This is probably crazy talk, but in Postgresql is there any way to have > >> a "keyed" sequence? That is, I have a table wi

Re: [GENERAL] "Keyed" sequence?

On 04/28/2016 08:48 PM, Israel Brewster wrote: >> >> On Apr 28, 2016, at 10:39 AM, Vik Fearing wrote: >> >> What would be the point of this? Why not just one sequence for all >> departments? > > continuity and appearance, not to mention simple logical progression. In this > case, the sequence i

Re: [GENERAL] "Keyed" sequence?

På torsdag 28. april 2016 kl. 20:30:20, skrev Israel Brewster < isr...@ravnalaska.net >: This is probably crazy talk, but in Postgresql is there any way to have a "keyed" sequence? That is, I have a table with a list of departments. While *relatively* static, technic

Re: [GENERAL] "Keyed" sequence?

--- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7293 --- BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brewster ORG:Frontier Flying Service

Re: [GENERAL] "Keyed" sequence?

On Thu, Apr 28, 2016 at 12:09 PM, Israel Brewster wrote: > > > > > It'll kill your performance, but if aesthetics are that important to > you... > > They're not *that* important. I was just asking if there was a way to do > this easily. > ​While the performance argument might be true it is heavi

Re: [GENERAL] "Keyed" sequence?

On Apr 28, 2016, at 11:21 AM, David G. Johnston wrote: > > On Thu, Apr 28, 2016 at 12:09 PM, Israel Brewster > wrote: > > > > > It'll kill your performance, but if aesthetics are that important to you... > > They're not *that* important. I was just asking if ther

Re: [GENERAL] "Keyed" sequence?

Adrian Klaver wrote: On 04/28/2016 11:48 AM, Israel Brewster wrote: On Apr 28, 2016, at 10:39 AM, Vik Fearing wrote: On 04/28/2016 08:30 PM, Israel Brewster wrote: This is probably crazy talk, but in Postgresql is there any way to have a "keyed" sequence? That is, I have a table with a list

Re: [GENERAL] Does this perf output seem 'normal'?

On 28.04.2016 17:50, Peter Devoy wrote: Also do you know that in perf report second column is the total cpu time share and not the first Thank you, I did notice they did not add up -- that makes more sense now. Can you expand node from perf report Yes, my pleasure. I added "--call-graph

Re: [GENERAL] Slow join over three tables

On Thu, 28 Apr 2016 16:38:53 +0200 Alban Hertroys wrote: Hi Alban First off ... thanks you for your time on this so far and giving me the educational smacks on the head :) I appreciate this a lot. > You're doing ~9 times as many index lookups. A slowdown of 6x of this > part of the query seem

Re: [GENERAL] xml-file as foreign table?

On Apr 28, 2016 14:33, "Johann Spies" wrote: > > I have several large (7GB+) xml files to get into an SQL database. > > The xml-files can contain up to 500 000 subrecords which I want to be able to query in the database. > > They are too large to do something like this: > > > insert into rawxml (x