Re: DBeaver postgres localhost access

2023-05-22 Thread Adrian Klaver
On 5/20/23 07:09, Pedro Gonçalves wrote: Hi. Good afternoon. I’m having dificulties with localhost DBeaver postgres training account. Had access to it and changed password, that presently don’t remember. What can I do to get access again? From DBeaver I was told to address this request to P

Re: DBeaver postgres localhost access

2023-05-22 Thread Ron
On 5/20/23 09:09, Pedro Gonçalves wrote: Hi. Good afternoon. I’m having dificulties with localhost DBeaver postgres training account. Had access to it and changed password, that presently don’t remember. What can I do to get access again? From DBeaver I was told to address this request to P

Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin

2023-01-25 Thread Ron
On 1/25/23 16:21, Dirschel, Steve wrote: [snip] The problem is users will connect using DBeaver and their sessions will sit idle. Idle is not a problem, "idle in transaction" is. From my perspective "idle in transaction" isn't necessarily a problem (although I don't like seeing sessions sitti

RE: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin

2023-01-25 Thread Dirschel, Steve
>> When I connect to the database through DBeaver with those 2 default >> settings changed and find that session in pg_stat_activity column >> xact_start is populated along with backend_xmin. Those get populated >> just by logging in. >As you found out in the log, the driver runs DbEaver run m

Re: DBeaver session populating pg_stat_activity.backend_xmin

2023-01-25 Thread Thomas Kellerer
Dirschel, Steve schrieb am 25.01.2023 um 20:36: When I connect to the database through DBeaver with those 2 default settings changed and find that session in pg_stat_activity column xact_start is populated along with backend_xmin. Those get populated just by logging in. As you found out in the

Re: DBeaver does not show all tables in a Schema

2021-10-29 Thread Adrian Klaver
On 10/29/21 03:46, Shaozhong SHI wrote: I used a DBeaver to connect to postgres but it does not show all tables in a schema. Can anyone shed light on this? Not without: 1) Postgres version 2) DBeaver version 3) JDBC version 4) Example of what you expect to see vs what you are seeing In ot

Re: DBeaver does not show all tables in a Schema

2021-10-29 Thread Shaozhong SHI
On Fri, 29 Oct 2021 at 14:53, Ryan Booz wrote: > In a recent update (not sure when), the default for DBeaver seems to have > changed so that the navigator view is set to "simple", rather than > "advanced" which shows all objects. > > Right-click the server -> edit connection -> Select "General" -

Re: DBeaver does not show all tables in a Schema

2021-10-29 Thread Ryan Booz
In a recent update (not sure when), the default for DBeaver seems to have changed so that the navigator view is set to "simple", rather than "advanced" which shows all objects. Right-click the server -> edit connection -> Select "General" -> verify "Navigator View" On Fri, Oct 29, 2021 at 9:48

Re: DBeaver does not show all tables in a Schema

2021-10-29 Thread Shaozhong SHI
It is a new installation with all permissions. Nothing has done to it. Regards, David On Fri, 29 Oct 2021 at 14:14, negora wrote: > Are you sure that you're not applying a filter in the "Database > Navigator" panel of DBeaver? > > Sometimes, it occurs to me that I apply a filter for certain d

Re: DBeaver does not show all tables in a Schema

2021-10-29 Thread negora
Are you sure that you're not applying a filter in the "Database Navigator" panel of DBeaver? Sometimes, it occurs to me that I apply a filter for certain database, I forget to remove it, then open another database, and some or all tables do not appear in the navigator. On 29/10/2021 12:46,

Re: DBeaver does not show all tables in a Schema

2021-10-29 Thread Ron
On 10/29/21 5:46 AM, Shaozhong SHI wrote: I used a DBeaver to connect to postgres but it does not show all tables in a schema. Can anyone shed light on this? Permissions? -- Angular momentum makes the world go 'round.

Re: dbeaver

2020-04-01 Thread negora
Both features reside only in the client side, of course. A virtual column allows to permanently show, in a table, a column calculated from a _javascript_-alike _expression_. That _expression_ is based on other columns of the table and offers several mathematica

Re: dbeaver

2020-04-01 Thread Thomas Kellerer
negora schrieb am 01.04.2020 um 21:44: It has lots of useful features, such as good query completion, row coloring, virtual columns, virtual foreign keys What kind of feature is "virtual foreign keys"? Or "virtual columns" in the context of a SQL GUI tool

Re: dbeaver

2020-04-01 Thread Ravi Krishna
> - does dbeaver is a good frontend for pg administration? It is an excellent sql client tool and I use it heavily for Redshift, SQLServer, Snowflake and PG. However it is a not dba tool in the sense that it can DBA specific details and graphs as shown in pgadmin.

Re: dbeaver

2020-04-01 Thread negora
On 01/04/2020 18:17, Roberto Della Pasqua wrote: > Hello, please some questions about a newbie Postgresql user: > > - what is the best method to keep the data replicated (for backup purposes): > Can be possible to deploy a master/slave with realtime data replication and > adding a storage where do

Re: dbeaver

2020-04-01 Thread Adrian Klaver
On 4/1/20 9:17 AM, Roberto Della Pasqua wrote: Hello, please some questions about a newbie Postgresql user: - what is the best method to keep the data replicated (for backup purposes): Can be possible to deploy a master/slave with realtime data replication and adding a storage where do a journa