nd the attachment for reference.
Thanks,
Postgann.
--
Adrian Klaver
adrian.kla...@aklaver.com
ATH=/usr/local/pgsql/bin/:$PATH
make
MAJORVERSION is 12
...
and the code compiles.
*Moses Mafusire*
--
Adrian Klaver
adrian.kla...@aklaver.com
t
that cannot be executed inside a transaction.
What are my options in this scenario?
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
n Friday, April 3, 2020, 11:39:57 AM EDT, Adrian Klaver
wrote:
On 4/3/20 5:53 AM, Moses Mafusire wrote:
> Hi Adrian,
> Thanks for your response. Here is what I'm getting when I run
/pg_config;/
> VERSION = PostgreSQL 12.1
So that is the correct version.
Just to be c
t; error exercise until you've got them all?
> >
> > Or is there a single command that with just delete the role and
do a
> > blanket grant removal at the same time?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/3/20 10:18 AM, Adrian Klaver wrote:
On 4/2/20 9:59 PM, AC Gomez wrote:
Granted. But we are where we are, so I'm assuming this is going to be
hand to hand combat.
Well you could even the odds somewhat by using the below as a starting
point:
SELECT
relname,
pg_roles.ro
er in order to edit it.
While you are in:
[postgres@dart-centos cstore_fdw]$
run:
/usr/bin/pg_config
and
/usr/pgsql-12/bin/pg_config
and confirm they are actually returning information.
Thanks
*Moses *
--
Adrian Klaver
adrian.kla...@aklaver.com
directory. If not
already done.
3) In the unpacked source directory run:
/usr/bin/pg_config
and
/usr/pgsql-12/bin/pg_config
4) Then:
PATH=/usr/bin/:$PATH make
Preferably with the modification to the Makefile I suggested upstream.
--
Adrian Klaver
adrian.kla...@aklaver.com
me that I may guilty of assuming. Have you installed the
CentOS development packages?:
https://www.scalescale.com/tips/nginx/install-gcc-development-tools-centos-7/
--
Adrian Klaver
adrian.kla...@aklaver.com
would also suggest looking at the Postgres log(assuming you have
log_statement set to at least mod) to see where in the sequence of
commands you run into the 'input'.
Can someone help me?
Thanks.
Arden
--
Adrian Klaver
adrian.kla...@aklaver.com
.
4) I don't see anything wrong the statements, so I am wondering if it is
a shell issue?
Thanks.
Arden
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/5/20 9:46 AM, Adrian Klaver wrote:
On 4/5/20 5:50 AM, arden liu wrote:
I am using psql to run this sql
file(https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl)
here is my command:
/usr/bin/psql postgresql://db_user:dbpassword@localhost
On 4/5/20 9:46 AM, Adrian Klaver wrote:
On 4/5/20 5:50 AM, arden liu wrote:
4) I don't see anything wrong the statements, so I am wondering if it is
a shell issue?
Seems to be. I removed the RETURNING *_id from the INSERT statements and
the file ran without interruption:
...
CREATE
_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET search_path = public, pg_catalog;
2) ALTER TYPE public.ancestry OWNER TO postgres;
On Sun., Apr. 5, 2020, 1:10 p.m. Adrian Klaver,
mailto:adrian.kla...@aklaver.com>> wrote:
On 4/5/20 9:46 AM, Adrian
auncher
14478 postgres 20 0 185252 9612 8184 S 0.000 0.119 0:00.00
postgres: postgres production [local] idle
14507 postgres 20 0 185348 11380 9848 S 0.000 0.141 0:00.00
postgres: aklaver task_manager ::1(45202) idle
--
Adrian Klaver
adrian.kla...@aklaver.com
quot;
Are you saying the functions are called to fill in fields in a UI form
or to populate a database side view?
--
Mark B
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/8/20 8:39 AM, Mark Bannister wrote:
On 4/8/2020 10:28 AM, Adrian Klaver wrote:
On 4/8/20 6:39 AM, Mark Bannister wrote:
I am converting an application to postgresql. On feature I have is
functions that return custom displays of a table row. For instance
the company display function
ay[('> N' collate "C") , ('< S' COLLATE "C")])
as s order by s;
s
-
< S
> N
(2 rows)
For more information see:
https://www.postgresql.org/docs/12/collation.html
Metadata:
- postgresql 9.5.19, running on Ubuntu 16LTS
- encoding, collate, and ctype are all UTF8 or en_US.UTF-8, as appropriate
Thanks!
Jimmy
--
Adrian Klaver
adrian.kla...@aklaver.com
and makes database management difficult.
I turned most of Nodes options in PgAdmin options off but pgadmin still
shows them. It shows also pg_toast schema.
That's something you probably need to ask the pgAdmin folks:
https://www.postgresql.org/list/pgadmin-support/
Andrus.
--
Adrian Kl
rg/docs/12/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
a point in time backup tool. If you want something that
continuously archives and prunes as it goes then you probably want to
look at the tools below:
https://pgbackrest.org/
https://www.pgbarman.org/
https://postgrespro.github.io/pg_probackup/
matthias
--
Adrian Klaver
On 4/14/20 11:16 PM, Matthias Apitz wrote:
El día Dienstag, April 14, 2020 a las 08:28:35 -0700, Adrian Klaver escribió:
On 4/14/20 8:00 AM, Matthias Apitz wrote:
Hello,
The run (as user 'postgres') on the server of the cmd:
pg_basebackup -U ${DBSUSER} -Ft -z -D
/data/postgresq
line is that when dealing with timestamps explicit is better
then implicit.
The fact that it knows the time zone is what makes everything
work. Timestamp without time zone is best avoided I think.
cheers,
raf
--
Adrian Klaver
adrian.kla...@aklaver.com
n database_name or the data is malformed.
CONTEXT: COPY abc.csv, line 1: "aa,bb,cc"
postgres=#
postgres=#
postgres=# select ftrelid::regclass::text from
pg_foreign_table
where ftrelid::regclass::text like '%abc.csv%';
ftrelid
---
"abc.csv"
(1 row)
Regards,
Virendra Kumar
--
Adrian Klaver
adrian.kla...@aklaver.com
ck with an
EXCEPTION clause. The syntax is an extension of the normal syntax for a
BEGIN block: ..."
Regards,
Virendra
On Thursday, April 16, 2020, 3:47:08 PM PDT, Adrian Klaver
wrote:
On 4/16/20 3:39 PM, Virendra Kumar wrote:
> Hello Everyone,
>
> I have a weird situation
er. I believe though that to help those that might
it would be helpful to show the actual code.
--
Adrian Klaver
adrian.kla...@aklaver.com
ython3.7/site-packages/psycopg2/__init__.py", line
130, in connect)
( conn = _connect(dsn, connection_factory=connection_factory,
**kwasync))
( could not translate host name "timescaledb" to address: Name or
service not known)
--
Adrian Klaver
adrian.kla...@aklaver.com
above does not look correct to me. Pretty sure the ',' does not
belong there.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/17/20 12:02 AM, Paul Förster wrote:
Hi Adrian,
On 17. Apr, 2020, at 03:00, Adrian Klaver wrote:
Huh? Leaving open connections is not considered a good thing. In other words a
connection should last for as long as it takes to get it's task done and then
it should close.
I basi
20, 8:15 PM Julien Rouhaud <mailto:rjuju...@gmail.com>> wrote:
On Fri, Apr 17, 2020 at 4:02 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
>
> On 4/17/20 6:31 AM, Sonam Sharma wrote:
> > I have setup db replication. And added
some tutorials
searching on 'node.js vue.js Sequelize postgresql'. Most seemed to use
express.js as the glue between node and vue.
Looking forward to your kind help.
Marco
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/20/20 11:29 AM, Marco Ippolito wrote:
Il giorno lun 20 apr 2020 alle ore 20:11 Adrian Klaver
mailto:adrian.kla...@aklaver.com>> ha scritto:
On 4/20/20 10:50 AM, Marco Ippolito wrote:
> I'm trying to connect to a postgres database (Postgresql-11)
within my
prose for the regular programmer, show us the code,
and point out what doesn't work for you, then we can help:-)
--
Andreas Joseph Krogh
--
Adrian Klaver
adrian.kla...@aklaver.com
-fdw.html
Summary:
1.SourceDB = PostgreSQL 9.6.11
2.TargetDB = PostgreSQL 9.6.14
3.Source Query = 15 columns with 3600 rows
4.Target Query via dblink: return 2365 rows only
Thanks, AJ
--
Adrian Klaver
adrian.kla...@aklaver.com
ften work / fail like this, then there’s no point
and we can wrap this up. But if not, I will happily post
what I have. Thank you.
This is too much prose for the regular programmer, show us the
code, and point out what doesn't work for you, then we can help:-)
--
Andreas Joseph Krogh
--
Adrian Klaver
adrian.kla...@aklaver.com
0 misses, 255 dirtied
avg read rate: 0.000 MB/s, avg write rate: 30.586 MB/s
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.06 s
Regards,
Virendra Kumar
--
Adrian Klaver
adrian.kla...@aklaver.com
ating System
from a backup because I swapped a HDD out for a SSD.
Please see screenshot for reference.
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
got the exact same results. I should have read this:
https://www.postgresql.org/docs/12/routine-reindex.html
before.
--
Adrian Klaver
adrian.kla...@aklaver.com
ettext("number
of parameters must be between 0 and 65535\n"));
return 0;
}
--
Scott Ribe
scott_r...@elevated-dev.com
https://www.linkedin.com/in/scottribe/
--
Adrian Klaver
adrian.kla...@aklaver.com
source code for the data
insertion/modification workflow.
Have you looked at?:
https://www.postgresql.org/developer/backend/
Thank you for helping a beginner.
--
Adrian Klaver
adrian.kla...@aklaver.com
not, and you didn't take any explicit steps to backup and restore the
database itself, then your database may be corrupted and thus unable to
boot. The log file should indicate whether that is the case.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
version 9's start up name "pg_log" and that is the name of the file
in the data directory. Starting at /Library/PostgreSQL/12 as suggested
is a good bet
--
Adrian Klaver
adrian.kla...@aklaver.com
?:
log/
And under it for log files?
Thanks
*Sent:* Thursday, April 23, 2020 at 2:32 PM
*From:* "Dummy Account"
*To:* "Adrian Klaver"
*Cc:* "David G. Johnston" , "pgsql-general"
*Subject:* Re: Could Not Connect To Server
Hey David,
Can you tell me the
use a text editor to view the file(s)?
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
connect, I selected
what I think was called "clear password".
Nonetheless, I still have what pgAdmin calls the "master password".
So even if I did remove the password for "PostgreSQL" server, would I be
able to reset one?
*Sent:* Thursday, April 23, 2020 at 4:26
iately and delete this email and any attachments from any computer.
Vaso Corporation and its subsidiary companies are not responsible for
data leaks that result from email messages received that contain
privileged and confidential and/or protected health information (PHI).
--
Adrian Klaver
t has no constraints
e.g. PK. Verify data and then push into permanent table.
--
Stephen Clark
*NetWolves Managed Services, LLC.*
Sr. Applications Architect
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.cl...@netwolves.com
http://www.netwolves.com
--
Adrian Klaver
adrian.kla...@aklaver.com
throw in a
backup of some sort just before shutting down the server.
Thanks for your help.
Blessings,
-Tom
--
Adrian Klaver
adrian.kla...@aklaver.com
!
Well without:
1) Table schema.
2) EXPLAIN ANALYZE for the query(s)
there is really not information to formulate an answer.
ts
--
Adrian Klaver
adrian.kla...@aklaver.com
trying to create an empty DB with these same
settings but if I omit --lc-messages it uses the OS locale value, and I
can't set it to an empty string.
Don.
--
Don Seiler
www.seiler.us <http://www.seiler.us>
--
Adrian Klaver
adrian.kla...@aklaver.com
elp.
If there are objects in the 10 database that depend on the libraries
then I imagine deleting them won't help.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/1/20 3:39 PM, TalGloz wrote:
Adrian Klaver-4 wrote
Why not compile them against 11?
Then follow step 5) here:
https://www.postgresql.org/docs/12/pgupgrade.html
Step 5 doesn’t actually say how to compile them during the upgrade process
it just gives a warning about not to use "C
initdb data/ and that is not
possible as initdb will not work on a populated data/.
As I said from the beginning: moving the cluster but without the
databases in it.
Thanks
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/2/20 8:02 AM, Paul Förster wrote:
Hi Adrian,
On 02. May, 2020, at 16:59, Adrian Klaver wrote:
2) To create a new base/ you will need to initdb data/ and that is not possible
as initdb will not work on a populated data/.
you do the initdb and then copy the *.conf files from the tar
On 5/2/20 12:30 AM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/1/20 3:39 PM, TalGloz wrote:
Adrian Klaver-4 wrote
Why not compile them against 11?
Then follow step 5) here:
https://www.postgresql.org/docs/12/pgupgrade.html
Step 5 doesn’t actually say how to compile them during the upgrade
On 5/2/20 11:58 AM, Matthias Apitz wrote:
El día sábado, mayo 02, 2020 a las 08:23:52a. m. -0700, Adrian Klaver escribió:
On 5/2/20 8:02 AM, Paul Förster wrote:
Hi Adrian,
On 02. May, 2020, at 16:59, Adrian Klaver wrote:
2) To create a new base/ you will need to initdb data/ and that is
r/pgsql-12/bin/pg_config --includedir-server --->
/usr/pgsql-12/include/server (postgres.h is there)
I can't understand why it doesn't work.
Do you have Postgres 12 -dev package installed?
TalGloz
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.
On 5/2/20 12:39 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/2/20 12:28 PM, TalGloz wrote:
I'm trying to upgrade from PostgreSQL 10 to 12 and I need to compile all
my
manually created C extension functions against PostrgreSQL 12 before
starting the upgrade process. I have this Makefile
On 5/2/20 1:03 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/2/20 12:39 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/2/20 12:28 PM, TalGloz wrote:
I'm trying to upgrade from PostgreSQL 10 to 12 and I need to compile
all
my
manually created C extension functions against PostrgreSQL 12 b
On 5/2/20 1:09 PM, TalGloz wrote:
Adrian Klaver-4 wrote
Yes, they were created when using make against Postgres 10 and I clean them
every time when I try a different version of Postgres.
Well I'm reaching the end of what I can do. All I have left is that the
examples I have see
bious about whether overriding CXX is a good idea now, too.
(Likely the core setting is the same, but if it were pointing at a
different compiler that could cause trouble.)
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/2/20 2:44 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/2/20 2:18 PM, Tom Lane wrote:
TalGloz <
adrian.klaver@
The "include $(PGXS)" is defined in the Makefile. After changig the CXXFLAGS
Hmm, time to clean my glasses.
Have no idea what the below means.
to PG_C
ocal/include/seal/memorypoolhandle.h:61:9: note: candidate constructor
not viable: requires 0 arguments, but 1 was provided
MemoryPoolHandle() = default;
^
11 errors generated.
make: ***
[/usr/pgsql-12/lib/pgxs/src/makefiles/../../src/Makefile.global:1047:
seal_mean_cxx_v2.bc] Error 1
Why does it start executing the following after it did what it was supposed
to do?
/usr/lib64/ccache/clang -xc++ -Wno-ignored-attributes -fno-strict-aliasing
-fwrapv -O2 -I. -I./ -I/usr/pgsql-12/include/server
-I/usr/pgsql-12/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
-I/usr/include -flto=thin -emit-llvm -c -o seal_mean_cxx_v2.bc
seal_mean_cxx_v2.cpp
Best regards,
TalGloz
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
lots in PMChildFlags array");
return 0; /* keep
compiler quiet */
So:
1) What are your connection settings?
2) What is generating the client traffic?
3) Is there a pooler in front of the server?
--
Adrian Klaver
adrian.kla...@aklaver.com
stop
postgresql-10.service", is there a better way to do that?
2. Where do I set the "-f" flag if I choose to force reset?
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/3/20 3:11 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/3/20 2:53 PM,
Looks like you did not shutdown the 12 instance.
--
Adrian Klaver
adrian.klaver@
This is weird because "systemctl staus postgresql-12.service" shows that the
service is dead.
It is now:
"The data
On 5/3/20 3:33 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/3/20 3:11 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/3/20 2:53 PM,
Looks like you did not shutdown the 12 instance.
--
Adrian Klaver
adrian.klaver@
This is weird because "systemctl staus postgresql-12.service"
ion in the bareos or Postgres logs?
OS is FreeBSD 11.3-RELEASE-p8 r360175M i386
PostgreSQL 12.2 on i386-portbld-freebsd11.3, compiled by gcc9 (FreeBSD Ports
Collection) 9.3.0, 32-bit
autovacuum is Disabled.
Any particular reason for above?
cheerio,
PMc
--
Adrian Klaver
adrian.kla...@aklaver.com
show an example table relationship?
Thanks for any thoughts or ideas,
* Brian F
--
Adrian Klaver
adrian.kla...@aklaver.com
list so apologies in advance if
I’m not following etiquette or doing something incorrectly.
Thanks in advance.
Ken W
--
Adrian Klaver
adrian.kla...@aklaver.com
eeded.
So to be clear you did:
dnf update pgdg-fedora-repo
Have you manually edited the repo file?
Best,
Clifford
--
@osm_washington
www.snowandsnow.us <https://www.snowandsnow.us>
OpenStreetMap: Maps with a human touch
--
Adrian Klaver
adrian.kla...@aklaver.com
{"sample_id": 3, "freezer_fk": 2}
(1 row)
Thanks in advance
--
Adrian Klaver
adrian.kla...@aklaver.com
d run along to our DBA.
From the OS perspective, we are not seeing any problems with CPU,
memory or disk. We are running on RHEL 7.7
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
d run along to our DBA.
From the OS perspective, we are not seeing any problems with CPU,
memory or disk. We are running on RHEL 7.7
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
t;Whitespace is allowed before and after the range value, but any
whitespace between the parentheses or brackets is taken as part of the
lower or upper bound value. (Depending on the element type, it might or
might not be significant.)
"
SELECT 5::numeric <@ '(00,10]'::numrange;
?column?
--
t
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/6/20 9:19 AM, Thom Brown wrote:
On Wed, 6 May 2020 at 17:13, Adrian Klaver wrote:
On 5/6/20 9:00 AM, Thom Brown wrote:
Hi,
I noticed I'm getting an error when adding white space to a numeric
range. I can run this:
postgres=# SELECT 5::numeric <@ '(,10]'::nu
Can someone explain
* Why It is fetching more columns and more rows, incase of inner query ?
* Is there any option to really limit values with INNER JOIN, INNER
query ? If yes, can you please share information on this ?
Thanks in advance for your time and suggestions.
Regards, Amar
--
Adrian Klaver
adrian.kla...@aklaver.com
: (412) 848-5612
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/7/20 9:07 AM, Adrian Klaver wrote:
On 5/7/20 8:56 AM, Jasen Lentz wrote:
In Postgres 11.6-2, what is the default timeout for wal_sender_timeout
if it is commented out?
Form postgresql.conf
Oops, from.
# The commented-out settings shown in this file represent the default
values
basis.
Table size is only 25 gb.
Any help in this regard is appreciable.
Indexes are stored just like tables. From storage perspective there is
no difference between a table and an index.
So the sum of 10 different tables to 65GB, compared to 25GB of one table
sounds possible.
--
eton and I have
tables like program_0, program_1, etc. And I'd like to dump all the
tables but client_1 onwards.
Does anybody happen to know a way to accomplish it?
Thank you!
Eudald
--
Adrian Klaver
adrian.kla...@aklaver.com
e, shut it down, do the upgrade and the
password is munged. Seems like an odd occurrence, we have not noted any
other weird issues.
Anyone else see or hear of this?
Thanks
Tory
--
Adrian Klaver
adrian.kla...@aklaver.com
'137074931866340'::bigint)
Filter: (pi.app_id = '126502930200650'::bigint)
Buffers: shared hit=4
Planning time: 0.297 ms
Execution time: 891.686 ms
(20 rows)
On Thu, May 7, 2020 at 9:17 PM David G. Johnston
mailto:david.g.johns...@gma
ata before I do an alter, to
give someone more info, let me know
Tory
On Thu, May 7, 2020 at 12:08 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 5/7/20 11:55 AM, Tory M Blue wrote:
> Going from 9.5 to 12 and 2 times now, I've had a password either go
tion
from Oracle (unless you create temporary tables via that connection).
They are an implementation detail and should not bother you.
What is your problem with these schemmas?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
--
Adrian Klaver
adrian.kla...@aklaver.com
ker process died unexpectedly
Whereas a restore without -j4 succeeded.
Please come up with a more complete example.
Are you OS user "postgres" when you run that?
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/8/20 12:03 PM, Tory M Blue wrote:
On Thu, May 7, 2020 at 12:32 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 5/7/20 12:24 PM, Tory M Blue wrote:
> Yes same password, I'm using a basic alter command to put the right
> password back.
't it change the others as well? Why a
single password.
I would first confirm what password_encryption in postgresql.conf is set
to. By default it is set to 'md5'.
Super strange indeed :)
Tory
--
Adrian Klaver
adrian.kla...@aklaver.com
lieve then?
--
Adrian Klaver
adrian.kla...@aklaver.com
rs.
So to be clear both the 9.5 and 12 instance are running on the same OS
version?
>
Thanks
Tory
--
Adrian Klaver
adrian.kla...@aklaver.com
moment. Got to go finish cutting down a tree,
maybe the chainsaw will shake an another idea loose:)
-Tory
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/8/20 12:31 PM, Support wrote:
On 5/8/2020 12:18 PM, Adrian Klaver wrote:
On 5/8/20 12:14 PM, Support wrote:
Hi,
Despite of the --help saying that it's possible to gzip to STDOUT and
pipe it for another process
pg_basebackup fails saying that it's not possible to gzip to S
On 5/8/20 1:42 PM, Support wrote:
On 5/8/2020 1:24 PM, Adrian Klaver wrote:
On 5/8/20 12:31 PM, Support wrote:
On 5/8/2020 12:18 PM, Adrian Klaver wrote:
On 5/8/20 12:14 PM, Support wrote:
Hi,
Despite of the --help saying that it's possible to gzip to STDOUT
and pipe it for an
s in those fields is determined by the settings mentioned in the
link above.
Also, can we control when to log to display only select queries of a few
specific tables?
Not with the built in logger.
Other folks maybe able to point you at third party software that can do
this.
Thanks,
mary
ETAIL: Key (COALESCE(description, ''::character varying),
COALESCE(address_identifier_general, ''::character varying),
COALESCE(street, ''::character varying), COALESCE(postcode,
''::character varying))=(test, , anywhere, 1234) already exists.
Kind regards
Peter
--
Adrian Klaver
adrian.kla...@aklaver.com
would they have added?
I am going to pull the settings from postgres itself and compare 12 and
9.5 to see if there is something glaring.
Thanks! :)
Tory
--
Adrian Klaver
adrian.kla...@aklaver.com
Prostgres 12 installation and execute the upgrade command right away
without the "--check" flag I get the problem described in my original post.
Best regards,
TalGlo
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
installation and execute the upgrade command right away
without the "--check" flag I get the problem described in my original post.
How are you installing Postgres?
Are the 10 and 12 packages coming from the same location?
Best regards,
TalGlo
--
Sent from: https://www.postgresql
an improve this part. Can I skip it somehow and
launch the vacuum manually afterwards?
Per postgresql.conf, I gave:
work_mem = 128MB
maintenance_work_mem = 8GB
max_parallel_maintenance_workers = 16
max_parallel_workers = 16
The server has 44 GB available memory, and 24 cores.
Do you have any ideas how to speed-up the entire process?
--
Kouber Saparev
--
Adrian Klaver
adrian.kla...@aklaver.com
s I see:
1) ECPGtrans on line 6716: action "commit"; connection "sisis" occurs twice.
2) ECPGtrans on line 1222: action "rollback"; connection "sisis" Comes
from a line that precedes the INSERT you are interested in. Is there
some sort of nesting going on?
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
1401 - 1500 of 4935 matches
Mail list logo
