Re:

[Дмитрий Иванов]

If I understand correctly, you are trying to connect to the guest operating
system through the parent operating system's localhost (127.0.0.1) local
loopback. Moreover, it is not clear what mode the network of the guest
operating system is in. Connection is not possible in NAT mode. In
Host-Only Networking mode, you must specify the IP address of the guest
operating system. The encryption mode is irrelevant to the problem.
In any case, your problem is not related to the topic of the forum.
Check out the VirtualBox networking documentation.
https://www.virtualbox.org/manual/ch06.html
--
Regards, Dmitry!


пт, 4 авг. 2023 г. в 04:13, Frank Gunseor :

> Hello,
>
> I am trying to connect to a PostgreSQL database remotely.
>
> I have read the documentation for PostgreSQland pgAdmin, but apparently it
> is not sinking in or making sense.
>
> My situation is:
>
> I am running PostgreSQL 15 on a Windows 10 Pro virtual machine on
> VirtualBox. The virtual machine also has a Host Only Network besides the
> NAT Network. I want to connect to the database from my desktop that is
> hosting the VM with VirtualBox using pgAdmin. I can connect to the database
> on the virtual machine on VirtualBox using pgAdmin.
>
> Here is the connection string: "host=localhost port=5432
> dbname=googleLens user=postgres password=XXX sslmode=prefer
> connect_timeout=10".
>
> Do I need to remove the sslmode to connect remotely?
>
> The postgresql.conf  contains listen addresses = '*'.
>
> I have tried so many combinations in the pg_hba.conf that I am almost
> going blind.
>
> I can not connect using pgAdmin on the desktop.
>
> In the Register - Server windows under the General tab can the Name be
> anything?
>
> Under the Connection tab is the Host name/address the Host Only Network of
> the machine the server is running on?
>
> Everytime I try to connect I get an "Unable to connect to server,
> connection timeout expired" error!
>
> I would appreciate any and all help. Or point me to a clear resource.
> Please DO NOT tell me to RTFM because I HAVE done so numerous times.
>
> Thank you.
>
> Frank Gunseor
>
>
>

[no subject]

[Frank Gunseor]

Hello,

I am trying to connect to a PostgreSQL database remotely.

I have read the documentation for PostgreSQland pgAdmin, but apparently it
is not sinking in or making sense.

My situation is:

I am running PostgreSQL 15 on a Windows 10 Pro virtual machine on
VirtualBox. The virtual machine also has a Host Only Network besides the
NAT Network. I want to connect to the database from my desktop that is
hosting the VM with VirtualBox using pgAdmin. I can connect to the database
on the virtual machine on VirtualBox using pgAdmin.

Here is the connection string: "host=localhost port=5432 dbname=googleLens
user=postgres password=XXX sslmode=prefer connect_timeout=10".

Do I need to remove the sslmode to connect remotely?

The postgresql.conf  contains listen addresses = '*'.

I have tried so many combinations in the pg_hba.conf that I am almost going
blind.

I can not connect using pgAdmin on the desktop.

In the Register - Server windows under the General tab can the Name be
anything?

Under the Connection tab is the Host name/address the Host Only Network of
the machine the server is running on?

Everytime I try to connect I get an "Unable to connect to server,
connection timeout expired" error!

I would appreciate any and all help. Or point me to a clear resource.
Please DO NOT tell me to RTFM because I HAVE done so numerous times.

Thank you.

Frank Gunseor

Re: pt 2

[Aditya Toshniwal]

Hi Billy,

Please share the OS details.

On Thu, Aug 3, 2023 at 1:28 PM billy donald  wrote:

> Ive had an older version of postgresql and pgadmin installed on my pc for
> about 4 years, as i was practicing it a bit back than. trying to get back
> into it and i figure i needed to update everything. after doing so it will
> not open and gives me this error (picture below). i've been scouring google
> and forums trying to troubleshoot and fix things but im all over the place
> and im not sure if i even have the right files/values. i've uninstalled and
> reinstalled version 15 of PGSQL and v7.5 and 7.4 which i tried recently.
> same issue.
>
> [image: image.png]
>
>

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Re: Schema diff tools excludes the SET directive from the function header

[Дмитрий Иванов]

Конечно!
https://github.com/pgadmin-org/pgadmin4/issues/6651
--
С уважением, Дмитрий!


чт, 3 авг. 2023 г. в 12:17, Akshay Joshi :

> Hi
>
> Can you please log the issue on GitHub
> ?
>
>
> On Thu, Aug 3, 2023 at 6:18 AM Дмитрий Иванов 
> wrote:
>
>> Hi
>> Schema diff utilities exclude the SET directive from the function header
>> in compare mode.
>> Reproducing the problem:
>> 1. Create a copy of the database with the function containing the SET
>> directive
>> 2. Modify the function and perform the comparison.
>> In the resulting script, I am missing the SET directive in the function:
>>
>> CREATE OR REPLACE FUNCTION bpd.class_del(
>> iid bigint)
>> RETURNS void
>> LANGUAGE 'plpgsql'
>> COST 100
>> VOLATILE SECURITY DEFINER PARALLEL UNSAFE
>> <--SET search_path=bpd, err-->
>> AS $BODY$
>> --
>> Regards, Dmitry!
>>
>

pt 2

[billy donald]

Ive had an older version of postgresql and pgadmin installed on my pc for
about 4 years, as i was practicing it a bit back than. trying to get back
into it and i figure i needed to update everything. after doing so it will
not open and gives me this error (picture below). i've been scouring google
and forums trying to troubleshoot and fix things but im all over the place
and im not sure if i even have the right files/values. i've uninstalled and
reinstalled version 15 of PGSQL and v7.5 and 7.4 which i tried recently.
same issue.

[image: image.png]

pgadmin 4 Not opening

[billy donald]

[image: image.png]

Re: Assign User Defined DataType To Columns

[David G. Johnston]

On Wed, Aug 2, 2023 at 9:24 AM Phani Prathyush Somayajula <
phani.somayaj...@pragmaticplay.com> wrote:

> Hi All,
>
>
>
> I’ve a user defined data type as :
>
> CREATE TYPE uibackend."_operation" (
>

If you find yourself writing user-space code that uses "_{data type}" you
are doing something wrong.  That implementation detail is not something
that is exposed to the user.  If you want to deal with arrays of a type you
say:  {data type}[]

So casting some random text column to an array of operation is simply:

operation_text_col::operation[]

And you can get rid of the above CREATE TYPE command altogether.

David J.

Re: Schema diff tools excludes the SET directive from the function header

[Akshay Joshi]

Hi

Can you please log the issue on GitHub
?


On Thu, Aug 3, 2023 at 6:18 AM Дмитрий Иванов  wrote:

> Hi
> Schema diff utilities exclude the SET directive from the function header
> in compare mode.
> Reproducing the problem:
> 1. Create a copy of the database with the function containing the SET
> directive
> 2. Modify the function and perform the comparison.
> In the resulting script, I am missing the SET directive in the function:
>
> CREATE OR REPLACE FUNCTION bpd.class_del(
> iid bigint)
> RETURNS void
> LANGUAGE 'plpgsql'
> COST 100
> VOLATILE SECURITY DEFINER PARALLEL UNSAFE
> <--SET search_path=bpd, err-->
> AS $BODY$
> --
> Regards, Dmitry!
>