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
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
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
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,
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
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 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
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
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
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
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,
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
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:
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?
>
>
>
>
>
>
>
>
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
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
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
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
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
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
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
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
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
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=
24 matches
Mail list logo
