Seeking New Members for the Community Code of Conduct Committee

This message is being sent from the Community Code of Conduct Committee, with the approval of the Core Team. The PostgreSQL Community Code of Conduct Committee is approaching our first year anniversary. As part of the Community CoC policy, the Committee membership is to be refreshed on an annual

Re: pg_restore issues with intarray

Kevin Brannen writes: >> On 9/5/19 4:24 PM, Adrian Klaver wrote: >> > On 9/5/19 4:06 PM, Kevin Brannen wrote: >> >>> From: Adrian Klaver >> >>> >> >>> On 9/5/19 2:57 PM, Kevin Brannen wrote: >> I think I need some help to understand what’s going here because I >> can’t figure it out an

Re: pg_restore issues with intarray

On 9/5/19 5:05 PM, Kevin Brannen wrote: On 9/5/19 4:24 PM, Adrian Klaver wrote: On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping.

RE: pg_restore issues with intarray

> On 9/5/19 4:24 PM, Adrian Klaver wrote: > > On 9/5/19 4:06 PM, Kevin Brannen wrote: > >>> From: Adrian Klaver > >>> > >>> On 9/5/19 2:57 PM, Kevin Brannen wrote: > I think I need some help to understand what’s going here because I > can’t figure it out and google isn’t helping. >

Re: Question from someone who is not trained in computer sciences

Hi, I am very grateful for all your prompt replies, that’s fantastic since I got an answer to my question. I am going to digest all of it, and then decide what to do next. Once again, thanks a lot! Best regards, Judith > On 2019-Sep-05, at 19:08, Sam Gendler wrote: > > If I was in a hurr

Re: pg_restore issues with intarray

On 9/5/19 4:24 PM, Adrian Klaver wrote: On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping. This is for Pg 9.6.5. (Yes, we are upgr

Re: pg_restore issues with intarray

On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping. This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, or so the

Re: Question from someone who is not trained in computer sciences

If I was in a hurry to implement this, and I had a userbase that wasn't very experienced with managing relational databases, I'd write some code to automatically and periodically build a docker image with the latest data in it (however often is sufficient to meet your needs), and then I'd set up a

RE: pg_restore issues with intarray

> From: Adrian Klaver > > On 9/5/19 2:57 PM, Kevin Brannen wrote: > > I think I need some help to understand what’s going here because I > > can’t figure it out and google isn’t helping. > > > > This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, > > or so the plan is.) Pg code c

Re: pg_restore issues with intarray

On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping… This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, or so the plan is.) Pg code came from the community and we compiled it

Re: Question from someone who is not trained in computer sciences

On 9/5/19 2:00 PM, Judith Lacoste wrote: Hi, I think PostgreSQL is the solution for my needs, but I am not a programmer/coder.  If I can confirm PostgreSQL does what I need, I will have to hire someone to assist, I am willing to give the effort to learn myself but it may be difficult, my spec

Re: Environment Variable for --data-checksum during initdb

On 9/5/19 12:25 PM, Ray Cote wrote: I'm trying to remember what environment variable can be set --data-checksum before running postgresql-setup initdb. I know I've seen it but it escapes my recall at the moment. AFAIK it does not exist and do I not see anything here: https://doxygen.postgresq

pg_restore issues with intarray

I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping… This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, or so the plan is.) Pg code came from the community and we compiled it with no changes. This is on Centos 6.7, t

Re: Question from someone who is not trained in computer sciences

On 9/5/19 4:00 PM, Judith Lacoste wrote: Hi, I think PostgreSQL is the solution for my needs, but I am not a programmer/coder.  If I can confirm PostgreSQL does what I need, I will have to hire someone to assist, I am willing to give the effort to learn myself but it may be difficult, my spec

Re: Question from someone who is not trained in computer sciences

Hi Judith, Might be more than you are looking for, but . . . We’ve done something like this with a portable mapping system installed on a Raspberry Pi. Really!!, it works with Postgres and a webserver to serve out a replicated open software stack based mappint interface. Our focus was on usin

Re: Question from someone who is not trained in computer sciences

On Thu, Sep 5, 2019 at 2:00 PM Judith Lacoste wrote: > I think PostgreSQL is the solution for my needs, but I am not a > programmer/coder. I don't think that it's restricted to people that are computer scientists. At least, I certainly hope it isn't. SQL was originally supposed to be something t

Re: Question from someone who is not trained in computer sciences

On Sep 5, 2019, at 2:00 PM, Judith Lacoste wrote: > > Hi, > > I plan to install the database on a server in the office. Me and my four > colleagues will occasionally connect to this database when we are working in > other locations (usually hospitals or universities). In such remote > locatio

Question from someone who is not trained in computer sciences

Hi, I think PostgreSQL is the solution for my needs, but I am not a programmer/coder.  If I can confirm PostgreSQL does what I need, I will have to hire someone to assist, I am willing to give the effort to learn myself but it may be difficult, my specialities are biology and microscopy.  Or pe

Environment Variable for --data-checksum during initdb

I'm trying to remember what environment variable can be set --data-checksum before running postgresql-setup initdb. I know I've seen it but it escapes my recall at the moment. The PostgreSQL documentation has a nice page of environment variables for when PostgreSQL is running, but I'm not finding

Re: Rebuild pg_toast from scratch?

Moreno Andreo writes: > Il 05/09/19 15:53, Tom Lane ha scritto: >> TRUNCATE ought to be enough. > ... or do I need to truncate the "master" table (the table blobs are in)? Yeah, that one. regards, tom lane

RE: postgresql: Help with hstore hextension

Thanks for the information. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thursday, September 05, 2019 12:06 PM To: Lu, Dan Cc: pgsql-gene...@postgresql.org; Kelly, Kevin Subject: Re: postgresql: Help with hstore hextension "Lu, Dan" writes: > We are now trying to

Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

Tom Lane writes: > If you have the dump in a text file you could just edit it and remove > that line (it's only about a dozen lines in, typically). Otherwise > you could delete it with sed or the like, roughly > > pg_restore dumpfile | sed s'/^SELECT pg_catalog.set_config('search_path', '', > f

Re: Rebuild pg_toast from scratch?

Hi Tom and thanks for your time, Il 05/09/19 15:53, Tom Lane ha scritto: Moreno Andreo writes:     I have an issue with a Windows 10 PC with Postgres 9.1 x86. You realize 9.1 is long out of support ... Absolutely :-) I'm about to migrate it to 11 Now I need to recreate an empty copy of th

Re: postgresql: Help with hstore hextension

"Lu, Dan" writes: > We are now trying to create "hstore" extension and ran into the error below. > opm=# CREATE EXTENSION hstore; > ERROR: could not open extension control file > "/pgdbadevbal801/pg/PostgreSQL-10.7/share/postgresql/extension/hstore.control": > No such file or directory You ne

postgresql: Help with hstore hextension

Hello, We recently downloaded the "postgresql-10.7.tar.bz2" file from https://ftp.postgresql.org/pub/source/v10.7. We configure our installation as followed: ./configure --prefix=/hostname/pg/PostgreSQL-10.7 --with-systemd We created new database and things are working fine. We are now trying

Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

On 9/5/19 7:35 AM, Tom Lane wrote: Lele Gaifax writes: I'm hitting a problem very similar to the one described here[1] pg_restore dumpfile | sed s'/^SELECT pg_catalog.set_config('search_path', '', false);//' | psql targetdb There's been some discussion of providing a simpler way to do thi

Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

Lele Gaifax writes: > I'm hitting a problem very similar to the one described here[1] Yeah, nothing's been done about that yet :-( > where several of those columns are HSTOREs. Trying to restore a dump I get the > same error: "ERROR: operator does not exist: public.hstore = public.hstore". > Th

Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

On 9/5/19 7:16 AM, Lele Gaifax wrote: Hi all, I'm hitting a problem very similar to the one described here[1]: one of my databases have the following trigger CREATE TRIGGER trg_dn_customer_contents_950_reset_usable BEFORE UPDATE ON dn.customer_contents FOR EACH ROW

Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

Hi all, I'm hitting a problem very similar to the one described here[1]: one of my databases have the following trigger CREATE TRIGGER trg_dn_customer_contents_950_reset_usable BEFORE UPDATE ON dn.customer_contents FOR EACH ROW WHEN (OLD.usable IS NOT NULL AND OLD.usabl

Re: Rebuild pg_toast from scratch?

Moreno Andreo writes: >     I have an issue with a Windows 10 PC with Postgres 9.1 x86. You realize 9.1 is long out of support ... > Running some SELECTs we got "ERROR: could not open file > "base/48121/784576": No such file or directory" Ugh :-( > Now I need to recreate an empty copy of thi

Re: floating point output

> On Sep 4, 2019, at 9:14 PM, Adrian Klaver wrote: > >> On 9/4/19 5:23 PM, Rob Sargent wrote: >> I've found the description of floating point types (here >> ), >> but I'm looking for the rationale of the output format,

Rebuild pg_toast from scratch?

Hi,     I have an issue with a Windows 10 PC with Postgres 9.1 x86. Running some SELECTs we got "ERROR: could not open file "base/48121/784576": No such file or directory" I then ran select n.nspname AS tableschema,     c.relname AS tablename from pg_class c inner join pg_namespace n on (c.rel

Re: floating point output

On Thu, Sep 5, 2019 at 6:14 AM Adrian Klaver wrote: > Some examples would help explain your concerns. I guess the problem is with extra_float_digits. If greater then zero, the string representation of a real is at its minimum, that is only significative digits are there: restoredb=# set extra_fl

Re: Uninstall postgres

It's done. I have done it from path 😃. Thanks On Thu, Sep 5, 2019, 2:27 PM Andreas Joseph Krogh wrote: > På torsdag 05. september 2019 kl. 10:53:01, skrev Sonam Sharma < > sonams1...@gmail.com>: > > I have installed postgres with the source code option using configure > --prefix and then make in

Re: Uninstall postgres

På torsdag 05. september 2019 kl. 11:01:25, skrev Sonam Sharma < sonams1...@gmail.com >: It's saying gmake *** No rule to make Target uninstall. On Thu, Sep 5, 2019, 2:27 PM Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 05. september 2019 kl. 10:

Re: Uninstall postgres

It's saying gmake *** No rule to make Target uninstall. On Thu, Sep 5, 2019, 2:27 PM Andreas Joseph Krogh wrote: > På torsdag 05. september 2019 kl. 10:53:01, skrev Sonam Sharma < > sonams1...@gmail.com>: > > I have installed postgres with the source code option using configure > --prefix and th

Sv: Uninstall postgres

På torsdag 05. september 2019 kl. 10:53:01, skrev Sonam Sharma < sonams1...@gmail.com >: I have installed postgres with the source code option using configure --prefix and then make install. Can someone please help in uninstalling this. How to uninstall the postgres n

Uninstall postgres

I have installed postgres with the source code option using configure --prefix and then make install. Can someone please help in uninstalling this. How to uninstall the postgres now. The installation was done as postgres user.