Hi,
For records: "-doo "PRELUDE_STATEMENTS=SET ROLE admins" works with ogr2ogr
-append function. In my case, I need to update/overwrite several tables, so
I add small psql-query to remove existing tables from schema:
psql -t -c "SELECT
'DROP TABLE IF EXISTS \"' || schemaname || '\". \"' || tabl
Hi!
Just for records: PGDump is valid solution for this:
- First I created SQL file with ogr2ogr and "-f PGDump"-option
- Second, I uploaded result SQL file with psql: psql -t -q -c "SET ROLE
admins;" -f ./result.sql
So this is work-around to manage group roles.
Rgs,
Pekka
Pekka Sarkola
Gispo
Hi Even,
That's correct: I use ogr2ogr. At least I tested with "-overwrite", but I
will check how this works with "-update"
Rgs,
Pekka
Pekka Sarkola
Gispo Oy
pekka.sark...@gispo.fi - GSM +358 40 725 2042
www.gispo.fi – www.paikkatieto.com
pe 2. heinäk. 2021 klo 17.26 Even Rouault (even.roua
Hi!
PGDump: that might be the solution, I need to check. Thank you!
Yes, libpg-connection doesn't have role parameters. Maybe it should? I
don't know how, but you can define role settings in pgAdmin connections
Rgs,
Pekka
Pekka Sarkola
Gispo Oy
pekka.sark...@gispo.fi - GSM +358 40 725 2042
w
Pekka,
I suspect you use "ogr2ogr -f PostgreSQL PG:."
If you use rather "ogr2ogr -update PG:" you should be able to use
-doo (not sure the SET ROLE will work properly in that context though)
Even
Le 02/07/2021 à 08:52, Pekka Sarkola a écrit :
Hi!
We have a PostGIS database with log
Hi again,
GDAL is using the standand libpg-connect
https://www.postgresql.org/docs/12/libpq-connect.html and that does not have
support for defining roles during connect.
Do I understand right that your user "Joe" does not have direct CREATEDB
privileges but gets them through the admins role?
Hi,
I wonder if writing the output into pgdump
https://gdal.org/drivers/vector/pgdump.html and editing the SQL a bit could be
used as a workaround.
-Jukka Rahkonen-
Pekka Sarkola wrote:
> Hi!
> We have a PostGIS database with login roles and group roles (like "admins",
> "editors" and "view
Hi!
We have a PostGIS database with login roles and group roles (like "admins",
"editors" and "viewers"). We have defined that only "admins" can create new
schemas and tables (among other privileges). My problem is that I'd like to
use ogr2ogr to bulk load some data to a PostGIS database using ogr
