HI
I've got the right meanng of pg_hba.conf and pg_ident.conf.
My previous understanding was incorrect. I thought pgserver would automatically
handle the conversion between OS users and PostgreSQL roles.
Thanks all.
发件人: David G. Johnston
发送时间: 2023年8月28日 14
Hi community,
I am a student and I want to achieve lsm-tree index in postgresql, for my
database experiment,
I have already read the document of postgresql, and some postgresql's moudle
source, but I really don't know where to start this work.
Make a new extension like 'https://github.com/HypoPG/
On 9/18/23 14:46, Johnson, Bruce E - (bjohnson) wrote:
Reply to list also.
Ccing list to return your answer there.
It turned out that for some reason the perl DBD::Pg module was trying to
connect twice, the first failed because of a typo in the password, the
second because it tried to connect
"Johnson, Bruce E - (bjohnson)" writes:
> The error I am getting on the client is:
> password authentication failed for user "trav"
> connection to server at "dhbpostgres.pharmacy.arizona.edu" (10.128.206.109),
> port 5432 failed: FATAL: no pg_hba.conf entry for host "10.128.206.109",
> user "
> On Sep 18, 2023, at 11:45 AM, Johnson, Bruce E - (bjohnson)
> wrote:
>
> I am doing some testing trying to migrate some websites from using Oracle to
> Postgres. (Using Perl DBI and DBD::Pg as the connecting mechanism)
>
> (Server Environment Postgres 15 running on Ubuntu 22.04, client Ro
On 9/18/23 12:45, Johnson, Bruce E - (bjohnson) wrote:
I am doing some testing trying to migrate some websites from using
Oracle to Postgres. (Using Perl DBI and DBD::Pg as the connecting
mechanism)
(Server Environment Postgres 15 running on Ubuntu 22.04, client Rocky
Linux using the supplied
I am doing some testing trying to migrate some websites from using Oracle to
Postgres. (Using Perl DBI and DBD::Pg as the connecting mechanism)
(Server Environment Postgres 15 running on Ubuntu 22.04, client Rocky Linux
using the supplied PostgreSQL DBI and DBD::Pg packages)
The error I am gett
On Mon, 2023-09-18 at 15:08 +, Harry Green wrote:
> I am having trouble restoring a database backed up with pg_dump/pg_dump_all.
> The error messages I get are below and appear to suggest that certain
> sql-language or
> pl/pgsql-language functions which include an sql statement referencing a
On 9/18/23 08:16, Adrian Klaver wrote:
On 9/18/23 08:08, Harry Green wrote:
Hello,
I am having trouble restoring a database backed up with
pg_dump/pg_dump_all. The error messages I get are below and appear to
suggest that certain sql-language or pl/pgsql-language functions which
include an s
On Mon, Sep 18, 2023 at 8:32 AM Harry Green wrote:
> Any ideas how I can solve it?
>
It is most likely you have broken some kind of rule in your database
schema, but without seeing the dump file it is impossible to point out what
you have done wrong.
Relatedly, the bodies of functions are black
On 9/18/23 08:08, Harry Green wrote:
Hello,
I am having trouble restoring a database backed up with
pg_dump/pg_dump_all. The error messages I get are below and appear to
suggest that certain sql-language or pl/pgsql-language functions which
include an sql statement referencing a table are try
Hello,
I am having trouble restoring a database backed up with pg_dump/pg_dump_all.
The error messages I get are below and appear to suggest that certain
sql-language or pl/pgsql-language functions which include an sql statement
referencing a table are trying to be executed before the table whic
Summary
---
I need to set up a read-only DB on the cloud which will synchronize
with the read/write DB on my laptop whenever possible (that is,
whenever I connect my laptop to the Internet). Need some pointers on
what sort of replication that I'm supposed to use and how to set it
up.
Details
-
13 matches
Mail list logo
