Re: Peer authentication failed ???

Yes! Thanks so much it worked! On 10/3/23 9:37 a.m., Peter J. Holzer wrote: On 2023-10-03 05:55:51 -0400, Amn Ojee Uw wrote: psql -U my_group_worker -d my_group_db psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  Peer authenticat

Peer authentication failed ???

Hi there. Using the 'sudo -u postgres psql' command I created a group and two accounts in the group, I also created a database for one of the accounts. Now, I'd like to login PG-15, using my new account and connecting to my new database, but PG-15 complains. See the example below, I think it

Re: [EXT] YNT: Need help tuning a query

Wow!! This is what I call cryptic!! On 9/29/23 2:46 a.m., Vladimir Sitnikov wrote: Oh, I misplaced the added where conditions. It should have been as follows, however, the overall idea is the same --- orignial.sql +++ tuned_v2.sql @@ -83,6 +83,7 @@                                 AND

Re: PSQL = Yes ... JDBC = no ??

I see now, any suggestions as work around in JDBC? Thanks!! On 9/3/23 8:12 p.m., David G. Johnston wrote: On Sunday, September 3, 2023, Amn Ojee Uw wrote: Are you saying that JDBC cannot handle or process \gexec, since it is PG-15 exclusive? psql is a client application present

Re: PSQL = Yes ... JDBC = no ??

o the JDBC Statement.executeUpdate() method? Thanks in advance. PD: Are you saying that JDBC cannot handle or process \gexec, since it is PG-15 exclusive? On 9/3/23 12:04 p.m., Adrian Klaver wrote: On 9/3/23 09:00, Amn Ojee Uw wrote: Hello! This issue really puzzles me beyond intrigue. Why would this schem

PSQL = Yes ... JDBC = no ??

Hello! This issue really puzzles me beyond intrigue. Why would this schema: *SELECT 'CREATE DATABASE jme_test_database' WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'jme_test_database')\gexec* work when entered at the psql prompt, but not when passed as a parameter in a JDBC

Re: JDBC + PG-15 but not psql

On 8/22/23 8:31 a.m., Dave Cramer wrote: Hi Amn, What I don't understand is the requirement to set autocommit to true since this is the default ? Either way this is expected behaviour as psql also has autocommit true by default. Thanks, Dave Cramer On Mon, 21 Aug 2023 at 20:57, Amn Ojee

Re: JDBC + PG-15 but not psql

n you help me understand this issue better? I don't see anywhere in the code where you are attempting to create a tablespace ? Dave Cramer On Sun, 20 Aug 2023 at 11:17, Amn Ojee Uw wrote: Hello. I have searched the net in an attempt to find if others have had and resolved this

JDBC + PG-15 but not psql

Hello. I have searched the net in an attempt to find if others have had and resolved this challenge, but most of the sites talk about how, when using the psql, this error arises. In my case, the error arises only when access PG-15 using JDBC. JDBC connects to the database, but when trying to

Re: Creating a TABLESPACE

Sorry, did not mean it that way. Thanks for the advice. On 8/16/23 11:37 a.m., Ron wrote: Friendly tip: whatever else you do, don't write "Hello children!" in English to adults.  It's *highly insulting*. On 8/16/23 05:10, Amn Ojee Uw wrote: Hello children! -- Born in Ariz

Re: Creating a TABLESPACE

currency=1); CREATE TABLESPACE Cheers, Mateusz śr., 16 sie 2023 o 12:10 Amn Ojee Uw napisał(a): Hello children! I am learning how to create a tablespace, and AFAIK this are the steps to follow. First step is to create the directory where the database files will be created, for

Creating a TABLESPACE

Hello children! I am learning how to create a tablespace, and AFAIK this are the steps to follow. First step is to create the directory where the database files will be created, for that I am using the root directory '/database'. This directory is be owned by the postgres group. Example :

Re: A Good Beginner's Book

Thanks for the advice. I just ordered it from Amazon. On 8/12/23 6:59 p.m., Anthony DeBarros wrote: Hi, On Sat, Aug 12, 2023 at 6:23 PM Miles Elam wrote: > On 8/12/23 9:02 a.m., Amn Ojee Uw wrote: > > Is there a book to be recommended for PostgreSQL beginners? I’m t

Re: A Good Beginner's Book

*Addendum* : I am using JDBC as the framework. On 8/12/23 9:02 a.m., Amn Ojee Uw wrote: Hello folks. Is there a book to be recommended for PostgreSQL beginners? Thanks in advance.

A Good Beginner's Book

Hello folks. Is there a book to be recommended for PostgreSQL beginners? Thanks in advance.

Re: My 1st TABLESPACE

Regards. On 07/08/2023 07:43, Amn Ojee Uw wrote: I'd like to create a TABLESPACE, so, following this web page <https://www.postgresql.org/docs/current/sql-createtablespace.html>,  I have done the following : *mkdir /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/dat

My 1st TABLESPACE

I'd like to create a TABLESPACE, so, following this web page ,  I have done the following : *mkdir /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data* *sudo chown postgres:postgres

Re: role "my_account" does not exist

I came to understand PG a bit better and then understood where I had gone wrong. Thanks folks, but please ignore this email. My most sincere apologies. On 8/3/23 8:17 p.m., Amn Ojee Uw wrote: Hello! Following this web page <https://ubiq.co/database-blog/create-user-postgresql/>,

role "my_account" does not exist

Hello! Following this web page , I have tried to create a new role/user, but to no avail. After typing the following command : /*createuser --interactive --pwprompt*/ I get the following questions: Enter name of role to add:

Re: error: connection to server on socket...

Thank you Adrian. It Worked!!! On 8/1/23 2:55 p.m., Adrian Klaver wrote: On 8/1/23 11:42, Amn Ojee Uw wrote: Ah! Adrean, here is something interesting. /*pg_lsclusters*/ displays the following information /*Ver Cluster Port Status    Owner    Data directory  Log

Re: error: connection to server on socket...

log' for reading: No such file or directory*/ I hope I was able to answer all the interesting questions posted as reply to my original post. /Thanks folks, I really appreciate the time you have dedicated to my question./ On 8/1/23 10:35 a.m., Adrian Klaver wrote: On 8/1/23 03:22, Amn Ojee Uw wr

Re: error: connection to server on socket...

_*Addendum*_ I tried this, but to no avail : /*sudo systemctl start postgresql*/ On 8/1/23 6:22 a.m., Amn Ojee Uw wrote: Using the following command on my Debian 12 machine: /*sudo apt-get install postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib

error: connection to server on socket...

Using the following command on my Debian 12 machine: /*sudo apt-get install postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib postgresql-doc phppgadmin */ and following the instruction on this web page I

Completely Removing PostgreSQL

In my Debian 12, I have removed the following apps from my system by using the following commands: /*sudo apt-*//*get*//*–purge *//*remove*//*postgresql postgresql*//*-15*//*postgresql-client-common postgresql-common postgresql-contrib*//**//*sudo apt-*//*get*//*–purge

Re: Upgrading

PostgreSQL-12 and continue on with PostgreSQL-15. Please note that I installed using the following command /*sudo apt-get -y install postgresql-12*/ Thanks in advance. On 7/30/23 11:34 a.m., Peter J. Holzer wrote: On 2023-07-30 07:53:54 -0400, Amn Ojee Uw wrote: On my Debian 12, I installed

Upgrading

Just a quick question. On my Debian 12, I installed PostgreSQL-12, I'd like to upgrade to the latest release of PostgreSQL. So, my question is, what is the best way to upgrade to the next release of PostgreSQL? Thanks in advance.

Re: PostgreSQL - How to login with my Linux user account

message. /**/ What am I doing wrong? Is there a webpage that explains how to login to PostgreSQL as other than 'postgres'? Thanks in advance. On 7/27/23 8:19 p.m., Amn Ojee Uw wrote: psql -d mydb -U myuser -W

PostgreSQL - How to login with my Linux user account

I'd like to log into my newly installed PostgreSQL [ PostgreSQL 12.15 (Debian 12.15-1.pgdg120+1) ] using my linux account. In trying to do that this web page suggest that I enter : psql -d mydb -U myuser -W However,

Re: Nu-B here

Please note the following : /psql (12.15 (Debian 12.15-1.pgdg120+1 /Thanks in advance // On 7/20/23 10:41 a.m., Adrian Klaver wrote: On 7/19/23 23:32, Alban Hertroys wrote: On 20 Jul 2023, at 02:36, Amn Ojee Uw wrote: After this command 'sudo -u postgres psql' I get this message : could

My 1st JDBC and PostgreSQL

Following the example in : https://www.tutorialspoint.com/postgresql/postgresql_java.htm I wrote the bellow method : public void connectToDatabase() throws ClassNotFoundException, SQLException {     try {     this.perr(this.getDatabaseClass()); // org.postgresql.Driver = Class

Nu-B here

After this command 'sudo -u postgres psql' I get this message : *could not change directory to "/home/my_account": Permission denied** **psql (12.15 (Debian 12.15-1.pgdg120+1))** **Type "help" for help.* I tried using help, but to no avail. What am I doing wrong? Thanks in advance!