On Sat, Aug 5, 2023 at 10:10 AM jacktby jacktby wrote:
> How to solve the warning?
Use an explicit cast, if the types are correct.
Jeff
On Wed, Jul 19, 2023 at 8:37 PM Amn Ojee Uw wrote:
>
> Following the example in :
> https://www.tutorialspoint.com/postgresql/postgresql_java.htm
> I wrote the bellow method :
>
> public void connectToDatabase() throws ClassNotFoundException,
> SQLException {
> try {
>
On Tue, Jun 27, 2023 at 12:17 PM Tom Lane wrote:
>
> Adrian Klaver writes:
> > On 6/27/23 04:46, Bowen Shi wrote:
> >> I'd like to know is supporting trusted PL/Python still in the
> >> schedule? What is the reason for the current lack of support, and do
> >> we have any relevant email
On Mon, Jun 19, 2023 at 11:39 AM Daniel Gustafsson wrote:
>
> > On 19 Jun 2023, at 17:13, Sebastien Flaesch
> > wrote:
>
> > OpenSSL V1 goes end of support soon (see
> > https://www.openssl.org/policies/releasestrat.html) with replacement should
> > be OpenSSL V3.
> >
> > What is the strategy
On Sat, May 6, 2023 at 6:35 AM Thomas Munro wrote:
>
> On Sat, May 6, 2023 at 9:58 PM Evgeny Morozov
> wrote:
> > Right - I should have realised that! base/1414389/2662 is indeed all
> > nulls, 32KB of them. I included the file anyway in
> > https://objective.realityexists.net/temp/pgstuff2.zip
On Fri, May 5, 2023 at 9:50 AM sujay kadam wrote:
>
> I have enabled SSL in postgres on a different port using pgbouncer.
>
> I have changed the default port to 6432 and made it SSL enabled and
> configured pgbouncer to listen port 5432 which is non-ssl.
>
> But we are connecting directly using
On Mon, Apr 24, 2023 at 9:22 PM Jagmohan Kaintura
wrote:
>
> We are doing Migration from Oracle to PostgreSQL. In SOurce database we have
> Binary data stored using murmur3 hashing function. In Oracle this data is
> being generated from the Java code and inserted into the Oracle database.
>
>
On Fri, Mar 24, 2023 at 7:07 AM Inzamam Shafiq
wrote:
>
> Can someone please list pros and cons of MariaDB vs PostgreSQL that actually
> needs serious consideration while choosing the right database for large OLTP
> DBs (Terabytes)?
>
For me, security is important. I don't want to do a lot of
On Sat, Mar 18, 2023 at 6:02 PM Tomas Pospisek wrote:
>
> On 13.03.23 21:25, Joe Conway wrote:
>
> > Hmm, well big +1 for having swap turned on, but I recommend setting
> > "vm.overcommit_memory=2" even so.
>
> I've snipped out the context here, since my advice is very unspecific:
> do use swap
On Mon, Mar 13, 2023 at 1:21 PM Israel Brewster wrote:
>
> I’m running a postgresql 13 database on an Ubuntu 20.04 VM that is a bit more
> memory constrained than I would like, such that every week or so the various
> processes running on the machine will align badly and the OOM killer will
>
On Wed, Feb 22, 2023 at 8:35 AM Michael Arnold wrote:
>
> Am looking for guidance on how to fix a memory leak when using libpq
> PQExecParams(). Memory leaks through CRYPTO_zalloc() and arises when using
> json_agg(). None-JSON based PQExecParams() calls are not leaking.
>
> Using Postgresql
On Fri, Feb 10, 2023 at 10:04 AM Tom Lane wrote:
>
> =?UTF-8?Q?Jon_Erdman?= writes:
> > I've got a background worker that has a slow memory leak in it
> > somewhere. How can I get it to start under valgrind to get a memcheck
> > output from it?
>
> You have to valgrind the whole cluster AFAIK.
On Tue, Jan 31, 2023 at 3:03 AM Giovanni Biscontini
wrote:
> We're looking for a Open Source alternative to Rhel for our VM server
> dedicated to Postgresql (14->15) installations. We're testing Alma, Rocky,
> and Oracle distributions as they're compatible with Rhel package systems.
> Can you
On Fri, Nov 11, 2022 at 12:09 PM Zwettler Markus (OIZ)
wrote:
>
> I found this in PG14 è
>
> bash-4.4$ ./pg_isready --version
>
> pg_isready (PostgreSQL) 14.2
>
> bash-4.4$ ./pg_isready
>
> /var/run/postgresql:5432 - no attempt
>
> bash-4.4$ ./pg_isready -h localhost
>
> localhost:5432 - no
On Mon, Nov 7, 2022 at 8:25 PM Jan Bilek wrote:
> ...
> select * from pg_read_file('/etc/passwd' , 0 , 100); -> it's possible to
> display content of '/etc/passwd/' file
> select version(); -> Result of DBMS version request.
Input filtering may help in the interim, until you get the roles
On Mon, Nov 7, 2022 at 2:38 PM Tom Lane wrote:
>
> Willian Colognesi writes:
> > `I take it things were okay with the version you used previously?`
>
> > Yes, it was working pretty well in another instance with pg version
> > `12.4-1.pgdg18.04+1`, and we had to make a migration of one database
On Mon, Oct 24, 2022 at 6:38 AM chris navarroza
wrote:
>
> I install postgresql14.5 with the following commands
>
> sudo yum install postgresql14-server postgresql14-contrib
>
>
> sudo su postgres
>
> cd /tmp
>
> /usr/pgsql-14/bin/initdb -D /home/dmartuser/pgsql/14/data
>
> and update the
On Thu, Oct 13, 2022 at 12:13 AM gzh wrote:
>
> My PostgreSQL is deployed on Amazon RDS, so the password of PostgreSQL is
> random and has various reserved characters.
>
> I don't know if the reserved characters below are complete, and there are
> some characters (e.g. * , $) I tried without
On Wed, Oct 12, 2022 at 7:16 AM gzh wrote:
>
> I found that the password can't contain the % character, and the other
> special characters (* , $) are no problem.
You need to percent-encode the password if you wish to use the %
symbol in the password. There are other reserved characters that
On Tue, Oct 4, 2022 at 1:02 PM Ron wrote:
>
> Sometimes (both interactively and via script) I access a remote Pg server
> via just the bare host name "foobar", and other times via the FQDN
> "foobar.example.com".
>
> I've only been able to get this to work by having two lines in the .pgpass
>
On Sun, Sep 11, 2022 at 6:55 AM Sebastien Flaesch
wrote:
>
> The PostgreSQL doc says that if the application code is initializing OpenSSL,
> it should tell PostgreSQL libpq client library that OpenSSL initialization is
> already done:
>
>
On Fri, Sep 2, 2022 at 5:43 PM Christophe Pettus wrote:
>
> > On Sep 2, 2022, at 14:22, Jeffrey Walton wrote:
> > Given the NOTES in the man page, how do we determine if a user and
> > database are present using the shell? Is there another utility we
> > should be usin
Hi Everyone,
I'm struggling to set the admin/postgres user password and use it on
Fedora 36. This is a fresh install on a new VM. The admin's name is
postgres. We created the user, and used the passwd utility to set the
Linux password 'hi...HS'. The ellipses are over 28 characters, so it
is a
Hi Everyone,
I have another beginner question. I am trying to use pg_isready to
determine if a database and user are present. The program seems to
always succeed, even when I delete the user or the database.
This baffles me from the man page. I guess this explains the behavior
I am seeing.
On Fri, Sep 2, 2022 at 7:34 AM Peter J. Holzer wrote:
>
> On 2022-09-01 20:49:56 -0400, Jeffrey Walton wrote:
> > On Thu, Sep 1, 2022 at 8:23 PM Peter J. Holzer wrote:
> > >
> > > On 2022-09-01 18:16:14 -0400, Tom Lane wrote:
> > > > Jeffrey Walt
On Thu, Sep 1, 2022 at 8:51 PM Tom Lane wrote:
>
> "Peter J. Holzer" writes:
> > However, the symlink doesn't seem to be the culprit. If I run
> > % sudo -u postgres -H /usr/lib/postgresql/13/bin/psql
> > (which is not a symlink)
> > I get the same behaviour. So it seems that psql changes to its
On Thu, Sep 1, 2022 at 8:23 PM Peter J. Holzer wrote:
>
> On 2022-09-01 18:16:14 -0400, Tom Lane wrote:
> > Jeffrey Walton writes:
> > > We are having a heck of a time getting PostreSQL utilities to honor
> > > home directories. For example, when I execute this sc
Hi Everyone,
We are having a heck of a time getting PostreSQL utilities to honor
home directories. For example, when I execute this script:
sudo -H -u postgres PGPASSWORD=${password} \
psql -h "${hostname}" -U "${username}" -d "${database}" \
--command="..."
It produces
28 matches
Mail list logo
