Postgres Pro
Downloads
Home   >   mailing lists

Thread: PGAdmin IV and settings SQLite file location

PGAdmin IV and settings SQLite file location

From
Durumdara
Date:
Dear Support!

Do you have any parameter what controls thelocation of the SQLite file location?

For example:
"pgadmin4-exe /settings_file="s:\secret\blah\pgadmin4.db"


We want to put this file into a protected drive.

In PGAdmin III I can redefine the "PGPASSFILE" to set the location.

Thank you!

dd


Re: PGAdmin IV and settings SQLite file location

From
Murtuza Zabuawala
Date:
Hi,

you can always override default paths in pgAdmin4, Create a file named config_local.py (if not already present) at your installation location ../pgadmin4/web/ and add following code in your config_local.py,

SQLITE_PATH = 's:/secret/blah/pgadmin4.db'

Restart pgAdmin4 and check.


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Wed, Mar 7, 2018 at 6:50 PM, Durumdara <durumdara@gmail.com> wrote:
Dear Support!

Do you have any parameter what controls thelocation of the SQLite file location?

For example:
"pgadmin4-exe /settings_file="s:\secret\blah\pgadmin4.db"


We want to put this file into a protected drive.

In PGAdmin III I can redefine the "PGPASSFILE" to set the location.

Thank you!

dd



Re: PGAdmin IV and settings SQLite file location

From
Durumdara
Date:
Dear Support!


2018-03-07 15:40 GMT+01:00 Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>:
Hi,

you can always override default paths in pgAdmin4, Create a file named config_local.py (if not already present) at your installation location ../pgadmin4/web/ and add following code in your config_local.py,

SQLITE_PATH = 's:/secret/blah/pgadmin4.db'

Restart pgAdmin4 and check.

Thank you, it's working. Only one more question.
Do I need to rewrite this file in every PGAdmin IV update, or the installer keep it safely?

Thank you!

dd