Service file (pg_service.conf)

Hi In what path should the service file (pg_service.conf) be placed on the pgadmin web server in order to be used - by the users - when  creating connections ? Thanks for a very useful product Best Jan -- Jan Birk Høedvej 52 4450 Jyderup Denmark +45 31 54 64 10

Re: migrate off oracle data to postgres

tir, 31 03 2020 kl. 14:15 +, skrev Pepe TD Vo: > I have a huge data on Oracle, would you please suggest how to migrate all data > off Oracle to Postgres? Do I need to export into csv and upload to postgres? > Ora2pg is limited data from oracle to postgresql right? How huge is huge? We have u

Re: Moving pgadmin4.db to a new server

it. > 2) Go to browser and clean all the cache. > 3) Start pgAdmin4 and open a new window. > Let us know if this works. > > On Sun, Oct 20, 2019 at 12:51 PM Jan Birk wrote: > > Hi and thanks for your efforts and time > > > > > > > > søn, 20 10 2019 kl.

Re: Moving pgadmin4.db to a new server

Hi and thanks for your efforts and time søn, 20 10 2019 kl. 11:45 +0530, skrev Aditya Toshniwal: > How did you copy the .db file ? > Did you copy first and then started pgAdmin or started first and then copied. > When pgAdmin4 starts, it checks the schema version of .db file and applies the > migr

Re: Moving pgadmin4.db to a new server

no way of exporting pgAdmin4 settings. > > > -- Murtuza > > On Fri, 18 Oct 2019, 21:55 Jan Birk, wrote: > > Hi, > > > > We are running pgadmin4 v 3.4 and are migration to a new server and a new > > version 4.12.. > > > > We have copied the old pgadmin4.db to t

Moving pgadmin4.db to a new server

Hi, We are running pgadmin4 v 3.4 and are migration to a new server and a new version 4.12.. We have copied the old pgadmin4.db to the new server in order to keep the users settings and passwords. Settings is working but not the passwords. We get an "Failed to decrypt the saved password. Error

Re: export pgadmin user list

Hi, You can export a user list on several ways: 1) from the CLI use sqlite -- $ sqlite3 pgadmin4.db select * from user ; 2) create a postgres_fdw and have access from pgadmin4 it self --- https://wiki.postgresql.

Servergroups

Hi, Is it possible to have servergroups in a servergroup? Ex SERVER-GROUP: ->SERVER-GROUP1 -->server1 -->server2 ->SERVER-GROUP2 -->server3 -->server4 etc Best Jan

Re: How to deal with multiple accounts

Hi, For inspiration... We have/use a lot of clusters and databases in PGadmin. In PGadmin (the users view) it is organised by product (servergroups: server-group-product01 - server-test-database (cluster01) - server-pre-production (cluster02) - server-production (cluster03) server-group-product

Re: Query Tool Initialization Error

Hi, I have seen the same error when renaming the alias. In /etc/httpd/conf.d/pgadmin4-30.conf renaming the alias from: WSGIScriptAlias /pgadmin4-30 /usr/lib/python2.7/site-packages/pgadmin4-30-web/pgAdmin4.wsgi to WSGIScriptAlias /pgadmin4 /usr/lib/python2.7/site-packages/pgadmin4-30-web/

The sqlite database

venlig hilsen / Best regards Jan Birk Høvedstensvej 13 2650 Hvidovre Mobile: +45 41741615

User management via sqlite / pgadmin4.db

gards Jan Birk Høvedstensvej 13 2650 Hvidovre Mobile: +45 41741615