On Tue, 2020-12-01 at 14:38 +0700, mobigroup wrote:
> I have strange behaviour when EXPLAIN returns parallel execution plan but the
> query execution is not parallel. The query looks as
>
> SELECT
> plpgsql_function(...parameters…)
> FROM table as t
> WHERE id=
Hi,
When I m creating a test db user using below command using root OS user
sudo -u postgres createuser -p 5432 --pwprompt testuser
I am getting the attached error of port.
But my postgres services are running fine on port 5432, I am sharing
the screenshot of that also.
So please help me in le
Thanks for the ideas, I tested them:
>
> The essential question here is when the function is executed, so you should
> use
> EXPLAIN (VERBOSE) to see that.
Append (cost=0.00..5.12 rows=4 width=32)
-> Gather (cost=0.00..1.26 rows=1 width=32)
Output: plpgsql_function(...)
Work
On 12/1/20 12:51 AM, Atul Kumar wrote:
Hi,
When I m creating a test db user using below command using root OS user
sudo -u postgres createuser -p 5432 --pwprompt testuser
I am getting the attached error of port.
But my postgres services are running fine on port 5432, I am sharing
the screens
On 12/1/20 6:26 AM, Adrian Klaver wrote:
On 12/1/20 12:51 AM, Atul Kumar wrote:
Hi,
When I m creating a test db user using below command using root OS user
sudo -u postgres createuser -p 5432 --pwprompt testuser
I am getting the attached error of port.
But my postgres services are running
mobigroup writes:
>> Perhaps you didn't define it as PARALLEL SAFE.
> The function is marked as "PARALLEL RESTRICTED” because it’s uses temp tables
> (and I tested it as PARALLEL SAFE with the same result… parallelisation
> doesn’t work anyway).
If it writes into temp tables then it can't be r
Hi,
Can I create a FDW connection using an ODBC driver which is installed on a
remote host, e.g.
Postgres@Linux ==> FDW ==> ODBC@Windows ==> SQL-Server
In other words, must the ODBC driver be installed on the local Linux system?
Thanks,
Markus
Yes. The driver needs to be on the client
On Tue, Dec 1, 2020 at 8:34 PM Zwettler Markus (OIZ) <
markus.zwett...@zuerich.ch> wrote:
> Hi,
>
>
>
> Can I create a FDW connection using an ODBC driver which is installed on a
> remote host, e.g.
>
>
>
> Postgres@Linux è FDW è ODBC@Windows è SQL-Server
Tom,
Ok, but how about reading from temporary tables? We could mark the function as
"PARALLEL SAFE” instead of "PARALLEL RESTRICTED” in this case if it’s
important. Actually, I rewrote the function without temp tables access but
that’s not helpful - the function marked as "PARALLEL SAFE” is not
Client means Postgres Server / FDW in that case?
Von: Hemil Ruparel
Gesendet: Dienstag, 1. Dezember 2020 16:08
An: Zwettler Markus (OIZ)
Cc: pgsql-general@lists.postgresql.org
Betreff: Re: FDW using remote ODBC driver
Yes. The driver needs to be on the client
On Tue, Dec 1, 2020 at 8:34 PM Z
The machine you are trying to connect the postgres server from is the
client in this case. May be a laptop or a production VM or container.
On Tue, Dec 1, 2020 at 8:43 PM Zwettler Markus (OIZ) <
markus.zwett...@zuerich.ch> wrote:
> Client means Postgres Server / FDW in that case?
>
>
>
>
>
>
>
>
Wrong direction.
I want to do a Connection FROM Postgres@Linux using fdw + odbc TO
SQL-Server@Windows.
Question has been if the SQL-Server ODBC driver can also be installed on the
remote Windows Server in that case.
-Markus
Von: Hemil Ruparel
Gesendet: Dienstag, 1. Dezember 2020 16:17
An:
It needs to be installed on the machine with postgres
On Tue, Dec 1, 2020 at 8:53 PM Zwettler Markus (OIZ) <
markus.zwett...@zuerich.ch> wrote:
> Wrong direction.
>
>
>
> I want to do a Connection FROM Postgres@Linux using fdw + odbc TO
> SQL-Server@Windows.
>
>
>
> Question has been if the SQL-S
Hi,
Just to clarify that I am at root OS user, trying to create a test user
using postgres user(-u) with create user command.
Error screenshots are already shared with you.
Please re-check the same.
Regards
Atul
On Tuesday, December 1, 2020, Adrian Klaver
wrote:
> On 12/1/20 12:51 AM,
On Tue, 2020-12-01 at 15:23 +, Zwettler Markus (OIZ) wrote:
> I want to do a Connection FROM Postgres@Linux using fdw + odbc TO
> SQL-Server@Windows.
Is there any reason for not using tds_fdw?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Question has been for pure interest. I could use a remote ODBC driver with
Oracle ;-)
> -Ursprüngliche Nachricht-
> Von: Laurenz Albe
> Gesendet: Dienstag, 1. Dezember 2020 17:14
> An: Zwettler Markus (OIZ) ; Hemil Ruparel
>
> Cc: pgsql-general@lists.postgresql.org
> Betreff: Re: AW: F
Atul Kumar writes:
> Just to clarify that I am at root OS user, trying to create a test user
> using postgres user(-u) with create user command.
Given the reference to /var/run/postgresql, I'm suspecting that you
are running a server that thinks it should put its socket in /tmp,
but you have some
On 12/1/20 8:10 AM, Atul Kumar wrote:
Hi,
Just to clarify that I am at root OS user, trying to create a test user
using postgres user(-u) with create user command.
No you are not at root for the OS you are at OS user postgres connecting
as database user testuser.
Error screenshots are a
hi,
There is no directory of postgresql in /var/run.
Please help me out.
Regards,
Atul
On 12/1/20, Tom Lane wrote:
> Atul Kumar writes:
>> Just to clarify that I am at root OS user, trying to create a test user
>> using postgres user(-u) with create user command.
>
> Given the reference
On Tuesday, December 1, 2020, Atul Kumar wrote:
>
> There is no directory of postgresql in /var/run.
Wasn’t expecting there to be, that’s what you get the error.
> Please help me out.
>
Since “su - postgres” works for psql just do that for createuser.
Or do what Tom said and specify -h /tmp
My password had ascii spaces in it which the jdbc implementation stripped
as a part of normalization of scram passwords causing authentication
failures. I have submitted a PR. Hope it gets merged. The fix was literally
one character because of which I spent days chasing the bug lol
On Sun, Nov 29,
Thanks a lot Tom, I appended the -h /tmp and it worked.
I need just one more help from you.
Could you tell me that why & how that socket file existed in /tmp directory.
What is the practice to make sure that this file (.s.PGSQL.5432)
should be inside /var/run directory ? so that it will not thro
You might want to give
https://www.postgresql.org/docs/13/runtime-config-connection.html a read
regards
Andreas
Am 12/2/2020 um 8:02 AM schrieb Atul Kumar:
> Thanks a lot Tom, I appended the -h /tmp and it worked.
>
> I need just one more help from you.
>
> Could you tell me that why & how that
On Wednesday, December 2, 2020, Atul Kumar wrote:
> Thanks a lot Tom, I appended the -h /tmp and it worked.
>
> I need just one more help from you.
>
> Could you tell me that why & how that socket file existed in /tmp
> directory.
>
Because the server was configured that way:
https://www.postg
24 matches
Mail list logo
