Re: Jira database won't start after disk filled up

2018-03-04 Thread Vick Khera
On Fri, Mar 2, 2018 at 5:13 PM, Paul Costello wrote: > My hope is that I can get the db back to 1/10 and maybe we can, with > Atlassian's help, somehow sync the lucene files back to the db. I don't > think I will have any postgres data to work with beyond 1/10. > > Does this still sound do-able

Q: text palloc() size vs. SET_VARSIZE()

2018-03-04 Thread Albrecht Dreß
Hi all, I have a (hopefully not too dumb) question regarding the size allocation of a text return value in a C user-defined function. Basically, the function is somewhat similar to the copytext() example on . However, the function shall

Re: Q: text palloc() size vs. SET_VARSIZE()

2018-03-04 Thread Tom Lane
Albrecht =?iso-8859-1?b?RHJl3w==?= writes: > text *t = PG_GETARG_TEXT_PP(0); > size_tout_len = 0U; > // allocate to the max. possible output size > text *new_t = (text *) palloc(VARSIZE_ANY_EXHDR(t) + VARHDRSZ); > // copy data to VARDATA(new_t), and count byt

Re: Is there a continuous backup for pg ?

2018-03-04 Thread raf
Gary M wrote: > Vick, > > I would love to use ZFS, this project requires RHEL/SeLinux MLS. Without > MLS and RH support, ZFS is a no-go. btrfs could be an option. it does mostly the same things as zfs. > On Fri, Mar 2, 2018 at 2:34 PM, Vick Khera wrote: > > > On Fri, Mar 2, 2018 at 2:34 PM, G

momjian.us is down?

2018-03-04 Thread Igal
I am trying to connect to http://momjian.us/ but I get connection timeout (from Firefox): The connection has timed out The server at momjian.us is taking too long to respond.     The site could be temporarily unavailable or too busy. Try again in a few moments.     If you are unable to load a

Re: Is there a continuous backup for pg ?

2018-03-04 Thread Sameer Kumar
On Mon, Mar 5, 2018 at 6:58 AM wrote: > Gary M wrote: > > > Vick, > > > > I would love to use ZFS, this project requires RHEL/SeLinux MLS. Without > > MLS and RH support, ZFS is a no-go. > > btrfs could be an option. it does mostly the same things as zfs. > AFAIK, btrfs is also not supported on

Re: momjian.us is down?

2018-03-04 Thread Adrian Klaver
On 03/04/2018 05:53 PM, Igal wrote: I am trying to connect to http://momjian.us/ but I get connection timeout (from Firefox): Works for me from FF. Maybe a caching issue? Have you tried: Ctrl + Shift + R The connection has timed out The server at momjian.us is taking too long to respond.

Re: momjian.us is down?

2018-03-04 Thread Igal
On 03/04/2018 07:24 PM, Adrian Klaver wrote: On 03/04/2018 05:53 PM, Igal wrote: I am trying to connect to http://momjian.us/ but I get connection timeout (from Firefox): Works for me from FF. Maybe a caching issue? Have you tried: Ctrl + Shift + R Thanks, I'm not  sure if something else w

Pgadmin4 apt packages.

2018-03-04 Thread Tim Uckun
Where are the pgadmin4 apt packages? I have set up the PPA as specified on the download page but I see no pgadmin4 packages in the list. I am running ubuntu 17-10 but I had to set up the zesty PPA because there are apt repos for artfful.

Re: Pgadmin4 apt packages.

2018-03-04 Thread Adrian Klaver
On 03/04/2018 07:47 PM, Tim Uckun wrote: Where are the pgadmin4 apt packages? I have set up the PPA as specified on the download page but I see no pgadmin4 packages in the list. I am running ubuntu 17-10 but I had to set up the zesty PPA because there are apt repos for artfful. https://wi

Re: momjian.us is down?

2018-03-04 Thread Tom Lane
Igal writes: > On 03/04/2018 07:24 PM, Adrian Klaver wrote: >> On 03/04/2018 05:53 PM, Igal wrote: >>> I am trying to connect to http://momjian.us/ but I get connection >>> timeout (from Firefox): > Thanks, I'm not sure if something else was fixed, but now it works. I > don't think that it had

Re: momjian.us is down?

2018-03-04 Thread Igal
On 03/04/2018 09:57 PM, Tom Lane wrote: Igal writes: On 03/04/2018 07:24 PM, Adrian Klaver wrote: On 03/04/2018 05:53 PM, Igal wrote: I am trying to connect to http://momjian.us/ but I get connection timeout (from Firefox): Dunno if it's related, but large parts of the US Northeast were wi