Re: (Again) Column Store on PostGreSQL

Thanks Pavel and Pascal. I guess I was really optimistic about an early implementation ^^ Best regards, Simon Le ven. 4 janv. 2019 à 18:35, Pavel Stehule a écrit : > Hi > > pá 4. 1. 2019 v 17:12 odesílatel Simon AUBERT > napsal: > >> Hello, >> >> We can find this very informative blog post

Re: pg_restore restores privileges differently from psql

On 1/14/19 12:57 PM, Sherrylyn Branchaw wrote: I don't see how that can work: test=# \c prod_db You are now connected to database "prod_db" as user "postgres". prod_db=# CREATE SCHEMA test; CREATE SCHEMA prod_db=# GRANT ALL ON SCHEMA test TO prod_user; GRANT prod_db=# GRANT USAGE ON SCHEMA t

Re: pg_restore restores privileges differently from psql

Sherrylyn Branchaw writes: > I'm restoring the schema from one database (prod) to another (dev). There > are users that exist in prod that don't exist in dev. When the restore job > tries to grant privileges to nonexistent users in dev, I would like it to > generate an error, which is safe to igno

Re: Question about MemoryContextRegisterResetCallback

Michel Pelletier writes: > It mentions "on disk" does this mean the flattened representation must be > binary compatible with what matrix_send emits? They will likely be the > same now, so I can see this as a convenience, but is it a requirement? No, your on-the-wire representation for send/recv

Re: pg_restore restores privileges differently from psql

I don't see how that can work: test=# \c prod_db You are now connected to database "prod_db" as user "postgres". prod_db=# CREATE SCHEMA test; CREATE SCHEMA prod_db=# GRANT ALL ON SCHEMA test TO prod_user; GRANT prod_db=# GRANT USAGE ON SCHEMA test TO prod_and_dev_user; GRANT prod_db=# \c d

Re: pg_restore restores privileges differently from psql

On 1/14/19 12:04 PM, Sherrylyn Branchaw wrote: The above needs more information: 1) Are the dev_* databases on a different cluster? 2) If so did you run: CREATE ROLE prod_user; CREATE ROLE prod_and_dev_user; on that cluster first? I happened to put them all on the same cluster for my test ca

Re: pg_restore restores privileges differently from psql

The above needs more information: 1) Are the dev_* databases on a different cluster? 2) If so did you run: CREATE ROLE prod_user; CREATE ROLE prod_and_dev_user; on that cluster first? I happened to put them all on the same cluster for my test case, in order to reproduce the unexpected behavior

Re: pg_restore restores privileges differently from psql

On 1/14/19 10:15 AM, Sherrylyn Branchaw wrote: Hi, I'm running two Postgres 9.6.11 databases on RHEL 6.9. I'm restoring the schema from one database (prod) to another (dev). There are users that exist in prod that don't exist in dev. When the restore job tries to grant privileges to nonexiste

Re: Question about MemoryContextRegisterResetCallback

After absorbing some of the code you've pointed out I have a couple of questions about my understanding before I start hacking on making expanded matrices. Serializing sparse matrices can be done with _expand/_build functions, and the size is known, so I can implement the EOM_flatten_into_methods.

pg_restore restores privileges differently from psql

Hi, I'm running two Postgres 9.6.11 databases on RHEL 6.9. I'm restoring the schema from one database (prod) to another (dev). There are users that exist in prod that don't exist in dev. When the restore job tries to grant privileges to nonexistent users in dev, I would like it to generate an err

Sv: Re: sha512sum (program) gives different result than sha512 in PG11

På mandag 14. januar 2019 kl. 16:18:30, skrev Thomas Markus < t.mar...@proventis.net >: Hi, echo contains a trailing carriage return. Try echo -n "A" | sha512sum regards Thomas   Ha ha, didn't think of that!   Thanks:-)   -- Andreas Joseph Krogh CTO / Partner -

Re: sha512sum (program) gives different result than sha512 in PG11

Hi, echo contains a trailing carriage return. Try echo -n "A" | sha512sum regards Thomas Am 14.01.19 um 16:16 schrieb Andreas Joseph Krogh: Hi. Anyone can explain why these two don't give the same result? 1. $ echo "A" | sha512sum 7a296fab5364b34ce3e0476d55bf291bd41aa085e5ecf2a96883e593aa183

sha512sum (program) gives different result than sha512 in PG11

Hi.   Anyone can explain why these two don't give the same result?   1. $ echo "A" | sha512sum 7a296fab5364b34ce3e0476d55bf291bd41aa085e5ecf2a96883e593aa1836fed22f7242af48d54af18f55c8d1def13ec9314c92a0ba63f7663500090565  -   2. $ psql -A -t -c "select encode(sha512('A'), 'hex')" 21b4f4

Re: the installation of pgadmin4 makes me weep in frustration

> > pgadmin 4 is nothing to do with the PostgreSQL project itself, it's just a > third party client. > > There are many other third-party clients listed here - > https://wiki.postgresql.org/wiki/PostgreSQL_Clients - > most of them probably better than pgadmin4. Agreed. I use dbeaver and it is

Re: the installation of pgadmin4 makes me weep in frustration

Thanks to Postgres Debian/Ubuntu packaging team, Installing pgAdmin4 is straightforward task, 1) Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main 2) Import the repository signing key, and update the p

Re: the installation of pgadmin4 makes me weep in frustration

Hi Robert, Please try OmniDB: https://omnidb.org/en/ OmniDB is a database management tool that can be installed on Linux, Windows and MacOS, offering several features for managing PostgreSQL databases, for example: - monitoring dashboard - query plan visualization - psql-like console tab - debug

Re: the installation of pgadmin4 makes me weep in frustration

Just over a year ago, I started to look for free / open source clients for Postgres, and went through most of that list. Unless you are willing to pay for a commercial license, most of them are not close to PG or have some limitations that made them unusable for me. Several 'free' tools were limit

Re: the installation of pgadmin4 makes me weep in frustration

> On Jan 14, 2019, at 7:58 AM, robert wrote: > > Hi There > > > > first, thanks a lot for the great an beautiful software we get from > PostgreSQL and all people around it. > > But I wonder how it comes, that installing pgadmin4 is so incredibly hard? > > And no documentation. > > I wou

repmgr and SSH

Hi I would like to setup a repmgr configuration with one primary node, one standby node and one witness node. Regarding SSH configuration, the documentation is not clear, I think. Do we need to setup SSH between the three nodes or only between primary and standby no

Re: the installation of pgadmin4 makes me weep in frustration

On 14/1/19 9:58 π.μ., robert wrote: Hi There first, thanks a lot for the great an beautiful software we get from PostgreSQL and all people around it. But I wonder how it comes, that installing pgadmin4 is so incredibly hard? And no documentation. I would like to install pgadmin4 to my ubun