Re: [EXTERNAL] - Re: pgAdmin IV

[Dave Page]

I've rejected that I'm afraid, with the note:

=
Bug 2880 refers to what happens if you execute "EXPLAIN SELECT..." as the
query, and that still works fine.

We use JSON output when you use the EXPLAIN *button*, because we need to
parse the output to render it in the graphical viewer. Whilst it's true
pgAdmin 3 parsed the output from the non-JSON EXPLAIN, it was complex code
that wasn't reliable or future-proof.
=

In short, if you want to see multi-line, indented text plans, prepend
"EXPLAIN " to the query and run it. If you use the EXPLAIN button, the
returned data is in JSON format and is intended for graphical rendering.

On Wed, Jun 5, 2019 at 3:32 PM Strauch, Sheldon  wrote:

> Issue #4327 <https://redmine.postgresql.org/issues/4327> created.
>
> On Wed, Jun 5, 2019 at 12:27 AM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Michelle,
>>
>> On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan 
>> wrote:
>>
>>> Aditya,
>>>
>>>
>>>
>>> That is not very intuitive!  Why can’t the information be displayed?
>>> All of the other database tools for other databases allow this.
>>>
>> This can be done if we split the JSON data and show it in multiple rows.
>> Kindly raise a feature request here-
>> https://redmine.postgresql.org/projects/pgadmin4/issues/new
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__redmine.postgresql.org_projects_pgadmin4_issues_new&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=3ibwePEFSbRp8mLattu4u3GqYxPjLg-iLtdNU4yEp6c&e=>
>>
>>>
>>>
>>> Thanks,
>>>
>>> Michelle
>>>
>>>
>>>
>>> *From:* Aditya Toshniwal 
>>> *Sent:* Tuesday, June 04, 2019 10:50 AM
>>> *To:* Michelle Schwan 
>>> *Cc:* pgadmin-support lists.postgresql.org
>>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.postgresql.org&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=8guLseXWlVR6QzGAZayTiHbnygOxLH826F2Z6XchUjU&e=>
>>> 
>>> *Subject:* [EXTERNAL] - Re: pgAdmin IV
>>>
>>>
>>>
>>> You need to double click on the "[" cell. It is a json data.
>>>
>>>
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Aditya Toshniwal
>>>
>>>
>>>
>>>
>>>
>>> On Tue, Jun 4, 2019, 20:10 Michelle Schwan  wrote:
>>>
>>> This is in all versions of pgAdmin IV.
>>>
>>>
>>>
>>> When generating an explain plan for a query, the data output only
>>> returns “[“.  In pgAdmin III, there was a detailed output.
>>>
>>> It is easier to read the detailed data output than the explain pictures
>>> – I have to keep my mouse on the picture to read it, very inconvenient.
>>>
>>>
>>>
>>> Same query in pgAdmin III
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Michelle Schwan
>>>
>>> Database Architect
>>>
>>> msch...@opentext.com
>>>
>>> Phone: (519) 888 7111 ext 3241
>>>
>>> Website:
>>>
>>> www.opentext.com
>>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.opentext.com_&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=c5S9yU0UPmoD_-iAc50_U2-4lagrne_wrU7cQ1BhHuU&e=>
>>>
>>>
>>>
>>> [image:
>>> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
>>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.opentext.com_2_email-2Dsignature-2Dlogo&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=B2kJl_1nLERpWAeaf4qoeUMHgk_myAcCRBStx6XUmbc&e=>
>>>
>>> This email message is confidential, may be privileged, and is intended
>>> for the exclusive use of the addressee. Any other person is strictly
>>> prohibited from disclosing or reproducing it. If the addressee cannot be
>>> reached or is unknown to you, please inform the sender by return email and
>>> delete this email message and all copies immediately.
>>>
>>>
>>>
>>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> Software Engineer | EnterpriseDB India | Pune
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
>
> Look after your data, and your database will look after you. -- Simon Riggs
>
> Sheldon E. Strauch
> *Data Architect, Data Services *
> *O* 312-676-1556
> *M* 224-723-3878
>
> *Enova International, Inc.*
> *This transmission is confidential and may be privileged or proprietary.
> If you are not the intended recipient, you are not authorized to use the
> information in this transmission in any way. Please inform the sender
> immediately if you have received this transmission in error and permanently
> delete and destroy the original and any copies of the information.*
>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [EXTERNAL] - Re: pgAdmin IV

[Strauch, Sheldon]

Issue #4327 <https://redmine.postgresql.org/issues/4327> created.

On Wed, Jun 5, 2019 at 12:27 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Michelle,
>
> On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan 
> wrote:
>
>> Aditya,
>>
>>
>>
>> That is not very intuitive!  Why can’t the information be displayed?  All
>> of the other database tools for other databases allow this.
>>
> This can be done if we split the JSON data and show it in multiple rows.
> Kindly raise a feature request here-
> https://redmine.postgresql.org/projects/pgadmin4/issues/new
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__redmine.postgresql.org_projects_pgadmin4_issues_new&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=3ibwePEFSbRp8mLattu4u3GqYxPjLg-iLtdNU4yEp6c&e=>
>
>>
>>
>> Thanks,
>>
>> Michelle
>>
>>
>>
>> *From:* Aditya Toshniwal 
>> *Sent:* Tuesday, June 04, 2019 10:50 AM
>> *To:* Michelle Schwan 
>> *Cc:* pgadmin-support lists.postgresql.org
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.postgresql.org&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=8guLseXWlVR6QzGAZayTiHbnygOxLH826F2Z6XchUjU&e=>
>> 
>> *Subject:* [EXTERNAL] - Re: pgAdmin IV
>>
>>
>>
>> You need to double click on the "[" cell. It is a json data.
>>
>>
>>
>>
>>
>> Thanks,
>>
>> Aditya Toshniwal
>>
>>
>>
>>
>>
>> On Tue, Jun 4, 2019, 20:10 Michelle Schwan  wrote:
>>
>> This is in all versions of pgAdmin IV.
>>
>>
>>
>> When generating an explain plan for a query, the data output only returns
>> “[“.  In pgAdmin III, there was a detailed output.
>>
>> It is easier to read the detailed data output than the explain pictures –
>> I have to keep my mouse on the picture to read it, very inconvenient.
>>
>>
>>
>> Same query in pgAdmin III
>>
>>
>>
>> Thanks,
>>
>> Michelle Schwan
>>
>> Database Architect
>>
>> msch...@opentext.com
>>
>> Phone: (519) 888 7111 ext 3241
>>
>> Website:
>>
>> www.opentext.com
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.opentext.com_&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=c5S9yU0UPmoD_-iAc50_U2-4lagrne_wrU7cQ1BhHuU&e=>
>>
>>
>>
>> [image:
>> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.opentext.com_2_email-2Dsignature-2Dlogo&d=DwMFaQ&c=lEzKI_JJakPtcnbAQ6Q5xQ&r=3P3-5UqoQFsuwPHL1Gr-FtP4nR5GVvvXlP89XkF_Y4w&m=8zZt5HIwmsAu_V7PoSM9pCSMM-F8nyKZ9nklwYM3s-o&s=B2kJl_1nLERpWAeaf4qoeUMHgk_myAcCRBStx6XUmbc&e=>
>>
>> This email message is confidential, may be privileged, and is intended
>> for the exclusive use of the addressee. Any other person is strictly
>> prohibited from disclosing or reproducing it. If the addressee cannot be
>> reached or is unknown to you, please inform the sender by return email and
>> delete this email message and all copies immediately.
>>
>>
>>
>>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Software Engineer | EnterpriseDB India | Pune
> "Don't Complain about Heat, Plant a TREE"
>


-- 

Look after your data, and your database will look after you. -- Simon Riggs

Sheldon E. Strauch
*Data Architect, Data Services *
*O* 312-676-1556
*M* 224-723-3878

*Enova International, Inc.*
*This transmission is confidential and may be privileged or proprietary. If
you are not the intended recipient, you are not authorized to use the
information in this transmission in any way. Please inform the sender
immediately if you have received this transmission in error and permanently
delete and destroy the original and any copies of the information.*

Re: pgAdmin IV

[Dave Page]

Hi

On Tue, Jun 4, 2019 at 3:28 PM Michelle Schwan  wrote:

> From version pgAdmin IV 4.6 and up, I am now receiving the following error
> message when I import a database into PostgreSQL.
>
>
>
> The database loads fine, but the error that public already exists seems
> strange.  Public is the default schema when creating a database – should
> the message just give a warning instead of an error?
>
> Having a Failed (exit code: 1) error makes it seem like the file did not
> load – when in fact it did.
>
> This should be handled better.
>
>
Those errors don't come from pgAdmin - they come from pg_restore (which is
part of PostgreSQL). pgAdmin is just displaying the output it gets from the
tool.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [EXTERNAL] - Re: pgAdmin IV

[Aditya Toshniwal]

Hi Michelle,

On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan 
wrote:

> Aditya,
>
>
>
> That is not very intuitive!  Why can’t the information be displayed?  All
> of the other database tools for other databases allow this.
>
This can be done if we split the JSON data and show it in multiple rows.
Kindly raise a feature request here-
https://redmine.postgresql.org/projects/pgadmin4/issues/new

>
>
> Thanks,
>
> Michelle
>
>
>
> *From:* Aditya Toshniwal 
> *Sent:* Tuesday, June 04, 2019 10:50 AM
> *To:* Michelle Schwan 
> *Cc:* pgadmin-support lists.postgresql.org <
> pgadmin-support@lists.postgresql.org>
> *Subject:* [EXTERNAL] - Re: pgAdmin IV
>
>
>
> You need to double click on the "[" cell. It is a json data.
>
>
>
>
>
> Thanks,
>
> Aditya Toshniwal
>
>
>
>
>
> On Tue, Jun 4, 2019, 20:10 Michelle Schwan  wrote:
>
> This is in all versions of pgAdmin IV.
>
>
>
> When generating an explain plan for a query, the data output only returns
> “[“.  In pgAdmin III, there was a detailed output.
>
> It is easier to read the detailed data output than the explain pictures –
> I have to keep my mouse on the picture to read it, very inconvenient.
>
>
>
> Same query in pgAdmin III
>
>
>
> Thanks,
>
> Michelle Schwan
>
> Database Architect
>
> msch...@opentext.com
>
> Phone: (519) 888 7111 ext 3241
>
> Website:
>
> www.opentext.com
>
>
>
> [image:
> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
> <http://www.opentext.com/2/email-signature-logo>
>
> This email message is confidential, may be privileged, and is intended for
> the exclusive use of the addressee. Any other person is strictly prohibited
> from disclosing or reproducing it. If the addressee cannot be reached or is
> unknown to you, please inform the sender by return email and delete this
> email message and all copies immediately.
>
>
>
>

-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

Re: pgAdmin IV

[Khushboo Vashi]

Hi,

Please log the issue @ https://redmine.postgresql.org/projects/pgadmin4

Thanks,
Khushboo

On Tue, Jun 4, 2019 at 7:46 PM Michelle Schwan  wrote:

> In versions 4.7 and 4.8 I am getting an error when trying to import a csv
> file into a table.
>
>
>
> The CSV file loads in pgAdmin III with no issues.
>
>
>
> The file size is 4,557,820 KB (only 5 columns in the table and 2
> indexes).  Smaller files load with no issues.
>
>
>
>
>
> Thanks,
>
> Michelle Schwan
>
> Database Architect
>
> msch...@opentext.com
>
> Phone: (519) 888 7111 ext 3241
>
> Website:
>
> www.opentext.com
>
>
>
> [image:
> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
> 
>
> This email message is confidential, may be privileged, and is intended for
> the exclusive use of the addressee. Any other person is strictly prohibited
> from disclosing or reproducing it. If the addressee cannot be reached or is
> unknown to you, please inform the sender by return email and delete this
> email message and all copies immediately.
>
>
>

RE: [EXTERNAL] - Re: pgAdmin IV

[Michelle Schwan]

Aditya,

That is not very intuitive!  Why can’t the information be displayed?  All of 
the other database tools for other databases allow this.

Thanks,
Michelle

From: Aditya Toshniwal 
Sent: Tuesday, June 04, 2019 10:50 AM
To: Michelle Schwan 
Cc: pgadmin-support lists.postgresql.org 
Subject: [EXTERNAL] - Re: pgAdmin IV

You need to double click on the "[" cell. It is a json data.


Thanks,
Aditya Toshniwal


On Tue, Jun 4, 2019, 20:10 Michelle Schwan 
mailto:msch...@opentext.com>> wrote:
This is in all versions of pgAdmin IV.

When generating an explain plan for a query, the data output only returns “[“.  
In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I 
have to keep my mouse on the picture to read it, very inconvenient.
[cid:image003.png@01D51AC1.4F95B800]

Same query in pgAdmin III
[cid:image002.png@01D51AC1.D939C5B0]

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com<mailto:msch...@opentext.com>
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com<http://www.opentext.com/>

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]<http://www.opentext.com/2/email-signature-logo>

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

Re: pgAdmin IV

[Aditya Toshniwal]

You need to double click on the "[" cell. It is a json data.


Thanks,
Aditya Toshniwal



On Tue, Jun 4, 2019, 20:10 Michelle Schwan  wrote:

> This is in all versions of pgAdmin IV.
>
>
>
> When generating an explain plan for a query, the data output only returns
> “[“.  In pgAdmin III, there was a detailed output.
>
> It is easier to read the detailed data output than the explain pictures –
> I have to keep my mouse on the picture to read it, very inconvenient.
>
>
>
> Same query in pgAdmin III
>
>
>
> Thanks,
>
> Michelle Schwan
>
> Database Architect
>
> msch...@opentext.com
>
> Phone: (519) 888 7111 ext 3241
>
> Website:
>
> www.opentext.com
>
>
>
> [image:
> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
> <http://www.opentext.com/2/email-signature-logo>
>
> This email message is confidential, may be privileged, and is intended for
> the exclusive use of the addressee. Any other person is strictly prohibited
> from disclosing or reproducing it. If the addressee cannot be reached or is
> unknown to you, please inform the sender by return email and delete this
> email message and all copies immediately.
>
>
>

pgAdmin IV

[Michelle Schwan]

This is in all versions of pgAdmin IV.

When generating an explain plan for a query, the data output only returns "[".  
In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures - I 
have to keep my mouse on the picture to read it, very inconvenient.
[cid:image003.png@01D51AC1.4F95B800]

Same query in pgAdmin III
[cid:image002.png@01D51AC1.D939C5B0]

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com<mailto:msch...@opentext.com>
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com<http://www.opentext.com/>

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]<http://www.opentext.com/2/email-signature-logo>

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

pgAdmin IV

[Michelle Schwan]

>From version pgAdmin IV 4.6 and up, I am now receiving the following error 
>message when I import a database into PostgreSQL.
[cid:image001.png@01D51AC0.3A964FB0]

The database loads fine, but the error that public already exists seems 
strange.  Public is the default schema when creating a database - should the 
message just give a warning instead of an error?
Having a Failed (exit code: 1) error makes it seem like the file did not load - 
when in fact it did.
This should be handled better.

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com<mailto:msch...@opentext.com>
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com<http://www.opentext.com/>

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]<http://www.opentext.com/2/email-signature-logo>

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

pgAdmin IV

[Michelle Schwan]

In versions 4.7 and 4.8 I am getting an error when trying to import a csv file 
into a table.

The CSV file loads in pgAdmin III with no issues.

The file size is 4,557,820 KB (only 5 columns in the table and 2 indexes).  
Smaller files load with no issues.

[cid:image002.jpg@01D51ABE.814440E0]

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

Re: PGAdmin IV in Firefox

[Durumdara]

Hi!



2018-05-08 12:40 GMT+02:00 Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com>:

>
>
> 2.) Many right clicks are handled by FF.
>>
> ​Can you provide some more details on this?​
>
>

As Jan wrote it. I clicked somewhere, for example Query Tool's grid, right
click on it, and then the browser's local menu appears.


>
> 3.) The closing of the tab gives me confirmation dialog, but after it
>> didn't ask for save query SQL content.
>>
> ​You mean when you close the browser itself?​
>
>

Not the whole browser, only the tab. The browser asks for closing, I say
yes, but then the PA4 don't ask me about opened Query tool windows (to save
them or not).

Thanks
   dd

Re: PGAdmin IV in Firefox

[Jan Claeys]

On Tue, 2018-05-08 at 16:10 +0530, Murtuza Zabuawala wrote:
> > 2.) Many right clicks are handled by FF.
> 
> Can you provide some more details on this?

Maybe this:

There is an option 'dom.event.contextmenu.enabled' which provides a
protection against websites that try to break your browser's normal
right click behaviour (which is showing the browser's context menu).

Obviously that interferes with what you would expect in something like
pgAdmin 4, and there are probably several other browser options &
browser extensions which might interfere with pgAdmin's intended
behaviour in similar ways.

I'm not so sure using a random _web_ browser is the best solution for
something like pgAdmin...


-- 
Jan Claeys

Re: PGAdmin IV in Firefox

[Murtuza Zabuawala]

Hi,

On Tue, May 8, 2018 at 3:05 PM, Durumdara  wrote:

> Hello!
>
> The old PGAdmins run in normal executable.
> The last version is visible in my browser (Firefox).
>
> Is there a way to restore it as normal exe?
>
​No, with version3.0 onwards pgAdmin4 will be using deafult browser from
user system in order to execute.​


>
> Sometimes it have side effects.
> 1.) I didn't see it separated, I need to find in FF tabs.
>
​You can detach the browser tab.​


2.) Many right clicks are handled by FF.
>
​Can you provide some more details on this?​


3.) The closing of the tab gives me confirmation dialog, but after it
> didn't ask for save query SQL content.
>
​You mean when you close the browser itself?​


> ​
>
>

> Thank you for the answer.
>
> dd
>

PGAdmin IV in Firefox

[Durumdara]

Hello!

The old PGAdmins run in normal executable.
The last version is visible in my browser (Firefox).

Is there a way to restore it as normal exe?

Sometimes it have side effects.
1.) I didn't see it separated, I need to find in FF tabs.
2.) Many right clicks are handled by FF.
3.) The closing of the tab gives me confirmation dialog, but after it
didn't ask for save query SQL content.

Thank you for the answer.

dd

Re: PGAdmin IV and settings SQLite file location

[Durumdara]

Dear Support!


2018-03-07 15:40 GMT+01:00 Murtuza Zabuawala <
murtuza.zabuaw...@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

Re: PGAdmin IV and settings SQLite file location

[Murtuza Zabuawala]

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  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
>
>
>

PGAdmin IV and settings SQLite file location

[Durumdara]

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