Joseph Maruca writes:
> I end up in the bash-4.1 shell. When executing the following command from
> within the shell: bash-4.1$ pg_dump db_name > /tmp/my_database.sql I am
> presented with the following error:
> pg_dump: [archiver (db)] connection to database "db_name" failed: could not
>
On Sunday, June 14, 2020, Joseph Maruca wrote:
>
> '''sudo -u postgres -H --psql -px -d db_name'''
>
> If I enter the following syntax from the RHEL command line:
>
> '''sudo su postgres'''
>
> I end up in the bash-4.1 shell. When executing the following command from
> within the shell:
Hello everyone,
I am trying to work out a way to perform a PostgreSQL pg_dump of a single DB
via RHEL v6.10 command line. Now the system I am working on is that you have to
shell into Bash 4.1 first before you get to PSQL. Now I can access the actual
PSQL db using the following syntax from the
On 6/13/20 10:03 PM, Niels Jespersen wrote:
Hello all
I just found out about the pg service file.
https://www.postgresql.org/docs/current/libpq-pgservice.html
I don’t know why it took me so long finding this. I have been looking
for ways to abstract physical details of data location away
On 6/14/20 12:17 AM, Abraham, Danny wrote:
Hi,
PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates
when in stress and many concurrent threads updating.
Is it BUG #11141 ( Duplicate primary key values corruption ). ?
Anyone aware of a resolution for this ?
According to the
On Sat, Jun 13, 2020 at 09:27:25PM -0400, Bruce Momjian wrote:
> On Sat, Jun 13, 2020 at 05:06:37PM -0500, Ron wrote:
> > On 6/13/20 1:46 PM, Bruce Momjian wrote:
> > > On Wed, Jun 3, 2020 at 08:53:45PM +0200, Andreas Joseph Krogh wrote:
> > > > I agree these are all technical issues, but
On Sat, Jun 13, 2020 at 10:13 PM Peter wrote:
> On Thu, Jun 11, 2020 at 10:35:13PM +0200, Magnus Hagander wrote:
> ! > Okay. So lets behave like professional people and figure how that
> ! > can be achieved:
> ! > At first, we drop that WAL requirement, because with WAL archiving
> ! > it is
9.5.5 is pretty old. I'd strongly think about updating to one of the
*seventeen* subsequent patch releases.
https://www.postgresql.org/docs/release/9.5.22/
On 6/14/20 2:17 AM, Abraham, Danny wrote:
Hi,
PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates
when in stress and
Hi,
PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates
when in stress and many concurrent threads updating.
Is it BUG #11141 ( Duplicate primary key values corruption ). ?
Anyone aware of a resolution for this ?
B.T.W - Looks like it happens less on Linux.
Thanks