Funny that you mentioned that. I created the view a couple of hours ago and
that resolve the problem. The view had the order by on the timestamp as
well so it does not have to send the data over for sorting. I wish there
was a way for postgres to allow control of what happens on which server
when
Hi Jorge,
Can you create a view in the source database such as
CREATE VIEW xxx_id_attributes AS
SELECT id, CAST(attributes->>'account_incident_id' AS integer)
FROM xxx WHERE attributes->'account_incident_id' ~ '^[0-9]+$';
On the remote server, create a foreign table on the new view and perform
I made a copy of the table and altered the column from hstore to jsonb.
Ran the following query with the same performance issues.
SELECT id, attributes FROM xxx WHERE account_id = 1 AND timestamp >=
'2019-01-16 22:34:28.584' AND CAST(attributes ->> 'account_incident_id' as
integer) = 2617116
I'm wondering if I can request that a blank SSH password would default to the
DB password (or vice-versa).
I'm refering to the login box when passwords aren't saved (but maybe this
would also apply when they are).
Alternately, it could be a checkbox (defaulting to on if the password is
blank):
I'm wondering if I can request that a blank SSH password would default to the
DB password (or vice-versa).
I'm refering to the login box when passwords aren't saved (but maybe this
would also apply when they are).
Alternately, it could be a checkbox (defaulting to on if the password is
blank):
Hi Dave,
Thank you for your response.
Where and how is the AES key safely stored then, in order to decript the
encrypted password? Or upon choosing to save a password we have to enter a
master password?
Best wishes,
Michel.
On Wed, Apr 17, 2019, 05:05 Dave Page wrote:
> Hi
>
> On Wed, Apr
Hi
On Wed, Apr 17, 2019 at 7:20 AM Michel Feinstein
wrote:
> Hi,
>
> I am new to pgAdmin and PostgreSQL. I am configuring a new server
> connection and I can see there's an option to save my server's password.
>
> How secure is this option? Does it save my password as plaintext or does
> it