again
Anaconda Prompt without any problem. So I think that postgres and conda
are like "fighting" for the PYTHONHOME variable name? Is this correct?
El mié., 10 jun. 2020 a las 10:08, Adrian Klaver
(mailto:adrian.kla...@aklaver.com>>) escribió:
On 6/9/20 10:38 PM, PEDRO PABL
provides?
2) Do you need the system Python you installed for anything that
Anaconda does not provide?
3) What are you planning to do with plpython3u?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/10/20 9:31 AM, Praveen Kumar K S wrote:
Hello,
Yes, both are part of dev. Should I clean the data directory on both
servers or only on master ?
Both otherwise the standby will be working with out of date data and
will not sync.
On Wed, Jun 10, 2020 at 7:50 PM Adrian Klaver
t import the library, then I'll have to code the
full function, but it's easier (for me) to code them in python language
rather than sql language.
El mié., 10 jun. 2020 a las 12:17, Adrian Klaver
(mailto:adrian.kla...@aklaver.com>>) escribió:
On 6/10/20 8:25 AM, PEDRO PABLO SE
ld be just Anaconda python and EDB python.
What happens if you try to create a plpythonu3u function in the
database?
The database crashes and tells me "*Connection to the server has
been lost.*"
El mié., 10 jun. 2020 a las 13:12, Adrian Klaver
(mailto:adrian.kla.
s/tagged/enterprisedb
I would try there.
--
Adrian Klaver
adrian.kla...@aklaver.com
than now. Maybe now I can ask a more concrete question about
paths.
Anyways, thank you very much for your time, Adrian. I really appreciate
it. If I manage to solve this I'll let you know, so if anyone else has
the same problem.
--
Adrian Klaver
adrian.kla...@aklaver.com
process.
That is spelled Oracle. Just kidding, no there is no such configuration.
--
Adrian Klaver
adrian.kla...@aklaver.com
line
error: pgbouncer: 11 unknown unit 'm'
error: found error in file pgbouncer, skipping
Look for var in file, line 1?.
Also something with 'm' as unit, I'm thinking around line 11?.
--
Adrian Klaver
adrian.kla...@aklaver.com
echTrend Inc.
8270 Willow Oaks Corporate Drive, Suite 625, Fairfax, VA 22031
Office: 703-521-9392 | Fax 703-663-8668
gdimopou...@techtrend.us <mailto:gdimopou...@techtrend.us>|
www.techtrend.us <http://www.techtrend.us/>
--
Adrian Klaver
adrian.kla...@aklaver.com
age-
From: Adrian Klaver
Sent: Thursday, June 11, 2020 4:03 PM
To: George Dimopoulos ; pgsql-gene...@postgresql.org
Subject: Re: ora2pg error : DBD::Oracle::db prepare failed: ORA-28110
On 6/11/20 12:32 PM, George Dimopoulos wrote:
Hi Everyone,
I am new to migrating oracle 18c EX to postgres.
I
/-- [ doesn't work
-- tx= [Timestamptz 'today', timestamptz 'now' + interval '1 hour');
-- working around the parser??
/tx = CONCAT('[', 'today'::Timestamptz,',',('now' ::Timestamptz
+ interval '1 hour'):: /timestamptz , ')'):: tstzrange ;
/RAISE NOTICE 'reassign %', tx;/
/answer = tx @> 'today'::Timestamptz;/
/RAISE NOTICE 'today %', answer;/
/answer = tx @> 'now'::Timestamptz;/
/RAISE NOTICE 'now %', answer;/
/END;/
/$$ /
--
Adrian Klaver
adrian.kla...@aklaver.com
stamptz 'today', timestamptz 'now' + interval '1 hour');
/-- [ doesn't work
-- tx= [Timestamptz 'today', timestamptz 'now' + interval '1 hour');
-- working around the parser??
/tx = CONCAT('[', 'today'::Timestamptz,',',('now' ::Timestamptz
+ interval '1 hour'):: /timestamptz , ')'):: tstzrange ;
/RAISE NOTICE 'reassign %', tx;/
/answer = tx @> 'today'::Timestamptz;/
/RAISE NOTICE 'today %', answer;/
/answer = tx @> 'now'::Timestamptz;/
/RAISE NOTICE 'now %', answer;/
/END;/
/$$ /
--
Adrian Klaver
adrian.kla...@aklaver.com
lege
---+--
role_test | t
command completed successfully , but verification statement showing he
doesnt have usage permission.
SELECT rolname, has_schema_privilege(rolname, 'public', 'usage') from
pg_roles;
this is strage. what could go wrong.
--
Adrian Klaver
adrian.kla...@aklaver.com
and provide complete sequence for above including
CREATE ROLE and what user you are doing the above as?
On Fri, Jun 12, 2020 at 10:11 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 6/12/20 3:56 PM, sekhar chandra wrote:
> I am not able to give usa
USAGE privileges on the
schema public. This allows all users that are able to connect to a given
database to create objects in its public schema. "
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
()?
What does the below show?
\l+
On Saturday, June 13, 2020, 05:12:32 PM CDT, Adrian Klaver
wrote:
On 6/13/20 2:52 PM, Shailesh Rangani wrote:
> + Community DL.
>
>
>
>
>
> On Saturday, June 13, 2020, 04:39:01 PM CDT, Shailesh Rangani
> mailto:shailesh.r
I get in a default installation. If I manually GRANT, it
changes to
2200 | public| 10 |
{postgres=UC/postgres,=UC/postgres,role_test=U/postgres}
What do you see?
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
ince. Then again it was a quick check. I would still take
Ron's advice and upgrade to latest minor release. If that does not fix
the problem then submit a bug report with a test case.
B.T.W - Looks like it happens less on Linux.
Thanks
Danny
--
Adrian Klaver
adrian.kla...@aklaver.com
change the settings for the
database(s) it connects to.
Thank you.
Regards Niels Jespersen
--
Adrian Klaver
adrian.kla...@aklaver.com
all outward
appearances. But to those who knew him well, he was a perfect gentleman
(Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
--
Adrian Klaver
adrian.kla...@aklaver.com
was, to all outward
appearances. But to those who knew him well, he was a perfect gentleman
(Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Tuesday, June 16, 2020, 10:39:45 AM EDT, Adrian Klaver
error?
What are the settings in the pg_hba.conf file?
--
Adrian Klaver
adrian.kla...@aklaver.com
using the correct password or that the
'postgres' user has a password?
--
Adrian Klaver
adrian.kla...@aklaver.com
whole copy will rollback. Given that the one file per
table might be preferable.
**
*Bach-Nga
--
Adrian Klaver
adrian.kla...@aklaver.com
as he
had four legs, a tail, and barked, I admit he was, to all outward
appearances. But to those who knew him well, he was a perfect gentleman
(Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On T
s.
I can connect from psql shell fine when it prompt hostname, username
(but connect to postgres not to PSmasteruser, PSmasteruser username set
up for aws maintenance postgres database, someone did, not me and the
password is same on both). Once I'm in psql and I can change to PSCIDR
ins
min.
v/r,
**
*Bach-Nga
--
Adrian Klaver
adrian.kla...@aklaver.com
| "C:\Program
Files\PostgreSQL\11\bin\psql" -U PSmasteruser -d PSCIDR -h
hostname.amazonaws.com -p 5432 password=mypassword
all usernames are same password.
thank you so much for all input.
v/r,
**
*Bach-Nga
--
Adrian Klaver
adrian.kla...@aklaver.com
** Genuinely rich *** Faithful talent *** Sharing success
On Friday, June 19, 2020, 09:19:35 AM EDT, Adrian Klaver
wrote:
On 6/19/20 4:12 AM, Pepe TD Vo wrote:
> thank you, I tried that too, remove the quote around the echo and it
> prompt for password, as I mentioned no matter I p
27;
Thank you again.
Bach-Nga
Sent from my Metro By T-Mobile 4G LTE Android Device
---- Original message
From: Adrian Klaver
Date: 6/19/20 09:58 (GMT-05:00)
To: Pepe TD Vo , cgerard...@gmail.com
Cc: Christopher Browne , Pgsql-admin
, Pgsql-general
Subject: Re: create batch s
On 6/19/20 7:52 AM, David G. Johnston wrote:
On Fri, Jun 19, 2020 at 6:58 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 6/19/20 6:53 AM, Pepe TD Vo wrote:
> Thank you sir and I am sorry for the typo not having "--" on
password.
>
w him well, he was a perfect
gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Friday, June 19, 2020, 10:57:59 AM EDT, Adrian Klaver
wrote:
On 6/19/20 7:52 AM, David G. Johnston wrote:
r.readthedocs.io/en/latest/ref/mysql.html
created in pgAdmin called called imagesdatabase and I'd prefer not to
break that since it took some time with AWS support to get that going.
--
Adrian Klaver
adrian.kla...@aklaver.com
thful talent *** Sharing success
On Friday, June 19, 2020, 02:24:05 PM EDT, Adrian Klaver
wrote:
On 6/19/20 8:30 AM, cgerard...@gmail.com <mailto:cgerard...@gmail.com>
wrote:
> There is an alternate solution, which is to launch pgadmin GUI, connect
> to the database, tic
he helps here.
Bach-Nga
Sent from my Metro By T-Mobile 4G LTE Android Device
Original message
From: "David G. Johnston"
Date: 6/19/20 20:24 (GMT-05:00)
To: pepevo
Cc: Adrian Klaver , cgerard...@gmail.com,
Christopher Browne , Pgsql-admin
, Pgsql-general
Subject
hen I try to stop it, it just hangs -
# systemctl stop postgresql-12 (hangs)
Can someone help how to resolve this?
Thanks,
Vishal
Looking at logs might help.
Regards,
Seenu.
--
Adrian Klaver
adrian.kla...@aklaver.com
#! Pavan Kumar
--*-
*Sr. Database Administrator..!*
*NEXT GENERATION PROFESSIONALS, LLC*
*Cell # 267-799-3182 # pavan.dba27 (Gtalk) *
*India # 9000459083*
*Take Risks; if you win, you will be very happy. If you lose you
will be Wise *
---*-
*Sr. Database Administrator..!*
*NEXT GENERATION PROFESSIONALS, LLC*
*Cell # 267-799-3182 # pavan.dba27 (Gtalk) *
*India # 9000459083*
*Take Risks; if you win, you will be very happy. If you lose you
will be Wise *
--
Adrian Klaver
adrian.kla...@aklaver.com
n, not encrypted.
The relevant section is:
http://www.pgbouncer.org/config.html#authentication-file-format
and it has quite a few caveats wrt SCRAM.
Thanks,
Stephen
--
Adrian Klaver
adrian.kla...@aklaver.com
ld be appreciated. Thanks in advance and sorry for my english
--
edugarg
--
Adrian Klaver
adrian.kla...@aklaver.com
as a
result of e-mail transmission. If verification is required please
request a hard-copy version.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/23/20 6:48 AM, Edu Gargiulo wrote:
On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 6/23/20 6:30 AM, Edu Gargiulo wrote:
> Hi all,
>
> We are using postgresql 11.7 on Debian.
> I noticed that pg_dum
pg_stats where attname like 'instr%_ref';
regards,
fabio pardi
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/23/20 6:48 AM, Edu Gargiulo wrote:
On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 6/23/20 6:30 AM, Edu Gargiulo wrote:
> Hi all,
>
> We are using postgresql 11.7 on Debian.
> I noticed that pg_dum
mpted for the password?
Do i need to change any configuration in pg_hba.conf file?
or add the user 'administrator' in the conf file.
On Thu, Jun 18, 2020 at 8:25 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 6/17/20 7:14 PM, prachi surangalikar wrote:
On 6/23/20 7:37 AM, Edu Gargiulo wrote:
On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 6/23/20 6:48 AM, Edu Gargiulo wrote:
> On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver
> mailto:adrian.kla...@aklaver.com>
<
On 6/23/20 9:44 AM, Edu Gargiulo wrote:
On Tue, Jun 23, 2020 at 11:45 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 6/23/20 7:37 AM, Edu Gargiulo wrote:
>
>
> On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver
> mailto:adrian.
On 6/23/20 3:16 PM, Bruce Momjian wrote:
On Sat, Jun 20, 2020 at 06:28:52PM +0200, Peter J. Holzer wrote:
On 2020-06-17 20:00:51 -0700, Adrian Klaver wrote:
On 6/17/20 7:14 PM, prachi surangalikar wrote:
i have tried every thing but still i could not find the solution to
this problem.
i
dat_sel_1, dat_sel_2, "\n\t\t . "sel_seq_1, sel_seq_2, "\n\t\t . "int_val_1, int_val_2, int_val_3,
int_val_4, int_val_5, "\n\t\t . "str_val_1, str_val_2, str_val_3, str_val_4, str_val_5, "\n\t\t . "valtype_1, valtype_2, valtype_3, valtype_4, valtype_5, valtype_6, valtype_7, "\n\t\t . "valmode_1, valmode_2,
valmode_3, valmode_4, valmode_5, valmode_6, valmode_7, "\n\t\t .
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/25/20 11:03 AM, Matthias Apitz wrote:
El día Donnerstag, Juni 25, 2020 a las 08:59:49 -0700, Adrian Klaver escribió:
On 6/25/20 5:54 AM, Matthias Apitz wrote:
El día jueves, junio 25, 2020 a las 01:11:37p. m. +0200, Matthias Apitz
escribió:
Hello
A PG dump file was produced on a
software
stack, but my first question here is: anybody out here who could manage
such an architecture successful working?
And please do not send hints of the type, rewrite everything in Java or
Visual Basic, as this is not an option :-)
Thanks
matthias
--
Adrian Klaver
adrian.kla
(further context for those curious: the discontinuity at 6/23 is due to
an individual autovacuum run getting stuck. After manually killing that
run, the next one succeeded and you see that reporting toward the right
of the graph)
Thanks!
Gabe
--
Adrian Klaver
adrian.kla...@aklaver.com
onfiguration gives the calling user the right to drop the
extension, but not to modify individual objects within it."
To mean that you could mark any extension as trusted in the control file
to allow non-superuser installation.
Thanks,
Brad
--
Adrian Klaver
adrian.kla...@aklaver.com
es removed seems to track the fact that the other tuples lines
increase because the VACUUM process was not working. The two data points
at the far right, when the auto VACUUM kicked in, back that up.
On Fri, Jun 26, 2020 at 12:02 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wro
Given that it is ANALYZE that is being cancelled I would run a
manual ANALYZE after the restore is done to update the database statistics.
Thanks
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/27/20 10:52 AM, Matthias Apitz wrote:
El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió:
2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task
2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table
"testdump.public.idm_ta
.
pg_read_file() -- Using file name from above.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
and then dump from the 9.3 running instance using the 9.6 pg_dump.
Thanks in advance
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/29/20 6:02 AM, Adrian Klaver wrote:
On 6/29/20 5:04 AM, Brad Thompson wrote:
Need to get 9.3 to install to recover a legacy system. We have a
legacy system that experienced a hardware failure requiring a OS
reload. Have installed 9.6 as an interim step but it won't let me get
t
meone who faced this problem?
Any idea how I can solve it ?
BTW: I don't have any problem with space.
The error says you do.
Where is pg_logical/snapshots/ mounted?
Are there specific restrictions on that mount?
Best Regard
--
Jaurès FOUTE
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/30/20 1:47 PM, FOUTE K. Jaurès wrote:
Le mar. 30 juin 2020 à 21:23, Bruce Momjian <mailto:br...@momjian.us>> a écrit :
On Tue, Jun 30, 2020 at 01:16:58PM -0700, Adrian Klaver wrote:
> On 6/30/20 11:03 AM, FOUTE K. Jaurès wrote:
> > Hi everyone,
>
?
--
Adrian Klaver
adrian.kla...@aklaver.com
snapshots /
1E-8567EB0.snap": No space left on device
What are the permissions on?:
pg_logical/snapshots/
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
--
Jaurès FOUTE
Technology Consultant
ISNOV SARL - Business Technology Consulting
On 7/1/20 11:21 AM, FOUTE K. Jaurès wrote:
Le mer. 1 juil. 2020 à 15:45, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit :
On 6/30/20 10:51 PM, FOUTE K. Jaurès wrote:
>
>
>
> From /var/lib/postgresql/12/main/pg_logical what
On 7/1/20 2:21 PM, FOUTE K. Jaurès wrote:
Le mer. 1 juil. 2020 à 22:15, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit :
On 7/1/20 11:21 AM, FOUTE K. Jaurès wrote:
>
>
> Has the problem occurred again?
>
> Yes
> 20
message
HINT: \set ON_ERROR_ROLLBACK on to rollback on error.
As someone working at a large company with an aweful lot of PostgreSQL,
thinking of the internal production systems I'm aware of, I'd personally
vote pretty strongly in favor of changing the default.
-Jeremy
--
Jer
them to inspect any other error more closely.
-Jeremy
--
Jeremy Schneider
Database Engineer
Amazon Web Services
--
Adrian Klaver
adrian.kla...@aklaver.com
row)
test(5432)=# select 1/0;
ERROR: division by zero
test(5432)=# select 1;
?column?
--
1
(1 row)
-Jeremy
--
Jeremy Schneider
Database Engineer
Amazon Web Services
--
Adrian Klaver
adrian.kla...@aklaver.com
workaround for that, other than storing data in normal tables."
Of course that does not apply to bytea:
https://www.postgresql.org/docs/12/datatype-binary.html
> 10. Blobs don’t participate in Logical replication.
--
Adrian Klaver
adrian.kla...@aklaver.com
How can I install only these packages without having to install the
entire postgres server ? TIA.
--
*Regards,
*
*K S Praveen Kumar
*
--
Adrian Klaver
adrian.kla...@aklaver.com
is not anymore on the installed list and I'm
not able to issue the psql command:
root@datastore-1:/home/user# sudo -u postgres psql
Error: PostgreSQL version 12 is not installed
How can I repair this?
Thanks in advance
Moreno.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 7/3/20 7:21 AM, Adrian Klaver wrote:
On 7/3/20 4:37 AM, Praveen Kumar K S wrote:
Hello,
PostgreSQL libraries are required while compiling pgpool. I need to
install postgresql-libs and postgresql-devel on Ubuntu Server 16.04
Why not install pgpool from package?
Assuming using PGDG repo
On 7/3/20 8:15 AM, Moreno Andreo wrote:
Il 03/07/2020 16:51, Adrian Klaver ha scritto:
On 7/3/20 1:54 AM, Moreno Andreo wrote:
Looks like the cluster was not removed from the pgcommon setup. This
would explain why you can't run psql. By default pgcommon looks for
the version of
ld and inserted with the same
number in $newhnr.
What helped was using:
$erg = &selectData("SELECT max(hnr) FROM acq_haushalt",[]);
if ($erg->{'CountData'} == 0) {
$newhnr=1;
}else{
$newhnr=$erg->{'Data'}->[0]->{$erg->{'Fields'}->[0]->{'Name'}}+1;
}
What we are doing wrong?
Thanks
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
asonable number of
other sessions also hitting the sequence.
Thanks for any help.
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
Regards
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
On 7/8/20 6:45 AM, Adrian Klaver wrote:
On 7/8/20 6:05 AM, Thomas Kellerer wrote:
Hello,
I noticed the following strage output when running Postgres 12.3 (not
psql) on Windows
postgres=# select pg_current_logfile();
pg_current_logfile
n this email are those of the sender and not Tesco.
Tesco Stores Limited Company Number: 519500 Registered in England
Registered Office: Tesco House, Shire Park, Kestrel Way, Welwyn Garden
City, AL7 1GA VAT Registration Number: GB 220 4302 31
--
Adrian Klaver
adrian.kla...@aklaver.com
?
Thanks in advance!
Regards
Luiz Hugo Ronqui
--
Adrian Klaver
adrian.kla...@aklaver.com
is taking upto 80 sec. thanks in
advance
The actual query and EXPLAIN ANALYZE for both runs of the query would be
useful.
Regards,
Vishwa S Kalyankar
--
Adrian Klaver
adrian.kla...@aklaver.com
43.21" (change in Year).
What could be the issue? we tried changing the default value to
"localtimestamp".
I would day the choices are:
1) A machine has it's clock set wrong.
2) The data is being loaded with a value for createdate that overrides
the DEFAULT.
Kindly
ust musing out loud, don't expect any kind of answer to that
here. :)
Already asked and not really answered:
https://www.postgresql.org/message-id/A51655C0-BDD0-4F52-8DC5-2672AADA32D0%40gmail.com
Thanks again everyone,
-Michel
--
Álvaro Herrera https://www.2ndQuadrant.com/
u looked in the Query History tab?:
https://www.pgadmin.org/docs/pgadmin4/4.23/query_tool.html#query-history-panel
Thanks - RW
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
s of DDL changes in one batchI'm
still looking how to see the results of the execution of each DDL statement.
On Unixen I would say tail the log file, not sure how that works in
Windows.
RW
--
Adrian Klaver
adrian.kla...@aklaver.com
=100) (actual
time=19901.708..19902.453 rows=252 loops=1)
Planning time: 0.154 ms
Execution time: 19951.016 ms
(3 rows)
IPDS_KSEB=#
On Fri, Jul 10, 2020 at 7:23 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 7/9/20 11:50 PM, Vishwa Kalyankar w
don't see
DEFAULT now() or localtimestamp randomly reverting back a year. There is
something else in this process that is setting the timestamp back.
As said out of 3k records , sometimes 50 to 100 records it shows as 2019.
Regards,
Deepika
On Fri, Jul 10, 2020 at 7:39 PM Adrian Klaver <
/transaction-iso.html
Thanks
RK
--
Adrian Klaver
adrian.kla...@aklaver.com
unzip the file first, then run pg_restore? Thanks
It depends on whether you dumped using the custom format -Fc or plain(no
-F or -Fp). If the custom format then you run pg_restore against it. If
the plain format then you will to unzip first then feed the file to psql.
--
Adrian Klaver
On 7/13/20 2:56 PM, Ron wrote:
On 7/13/20 2:32 PM, Adrian Klaver wrote:
On 7/13/20 12:12 PM, Julie Nishimura wrote:
Hello there,
One of our PostgreSQL 9.4.1 databases has been backed up as *.gz
file with the compression 9 "pg_dump -Z 9". What is the right format
of restore this
--
Jaurès FOUTE
--
Jaurès FOUTE
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: _jauresfo...@gmail.com <mailto:jauresfo...@gmail.com>_,
jauresmelki...@yahoo.fr <mailto:jauresmelki...@yahoo.fr>
Compte Skype: jauresmelkiore
--
Adrian Klaver
adrian.kla...@aklaver.com
seconds and re-issue the query, is
that likely to be sufficient?
I'm guessing not, you will need to issue the PREPARE again per the error
message:
"Prepared statement needs to be re-prepared"
--
Mike Nolan
htf...@gmail.com <mailto:htf...@gmail.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
is different for each row because random() is
volatile and thus evaluated for each row.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
give problems.
So there's some way to solve this problem or I just have to wait the new update?
thank you
||
--
Adrian Klaver
adrian.kla...@aklaver.com
PostgreSQL user ( with the Same name as of my JumpCloud/ Macbook
Pro user) directly from my Macbook Pro terminal using my JumpCloud
Password authentication?
What do I need to set up in pg_hba.conf ?
Please suggest in detail.
Thks
--
Adrian Klaver
adrian.kla...@aklaver.com
here is an error. >
psql: error: could not connect to server: FATAL: password
authentication failed for user "firstname.lastname"
On Thu, Jul 16, 2020 at 2:55 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 7/16/20 12:04 PM, Devraj B wrote:
>
e that to gzip with
appropriate options?
You will then need to use psql to do the restore though.
Thanks for your help...
--
--
Adrian Klaver
adrian.kla...@aklaver.com
r the gzip compression specification, and doesn't provide those two
features to control it's processing (or any features beyond what's
documented on the pg_dump reference page).
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
0 disk
└─md127 9:127 0 5.5T 0 raid0 /opt/postgres
/dev/md127 5.5T 5.2T 306G 95% /opt/postgres
Thanks & Regards,
Rajamohan.J
--
Adrian Klaver
adrian.kla...@aklaver.com
1601 - 1700 of 4936 matches
Mail list logo
