On 11/27/20 7:15 AM, Hemil Ruparel wrote:
The database has been upgraded
Just to be clear the postgresql.conf file has:
password_encryption = scram-sha-256
set correct?
On Fri, Nov 27, 2020 at 8:41 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 11/27/2
//127.0.0.1/32>
trust
host replication all ::1/128
trust
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
<https://www.cybertec-postgresql.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
tabase
user 0.0.0.0/0 <http://0.0.0.0/0> md5"
You have to remember we have no idea of how you are trying to make the
connection. So where does this failure occur, with all connection
methods, just DataGrip, some other method?
--
Adrian Klaver
adrian.kla...@aklaver.com
issing
something?
--
Adrian Klaver
adrian.kla...@aklaver.com
other way e.g. a newer version of pg_dump can dump an older
version of Postgres.
--
Adrian Klaver
adrian.kla...@aklaver.com
/pgjdbc/pgjdbc/issues/new
I was actually changing the database name and user name
On Sat, Nov 28, 2020 at 9:28 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 11/28/20 6:10 AM, Hemil Ruparel wrote:
> Line 88 is this line: host database user 0.0.0.0
pg_dump version. The dump/restore process is
not designed to go backwards.
On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 11/28/20 8:12 AM, mark armon wrote:
>
> OS: Windows
> issue:
>
https://stacko
the driver has been configured.
As you can see I've not been given a a lot to go on, unfortunately. Has
anyone seen this before? Is this a common issue and my google-fu has
failed me? :)
Many thanks.
Regards,
M.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/29/20 10:22 AM, Martin Goodson wrote:
On 29/11/2020 18:10, Adrian Klaver wrote:
On 11/29/20 10:06 AM, Martin Goodson wrote:
Hello.
I wonder if anyone can assist with this?
Some of my developers are reporting that they are getting the
following message when attempting to connect to the
connected to
postgres using psql command.
Regards,
Atul
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/1/20 6:26 AM, Adrian Klaver wrote:
On 12/1/20 12:51 AM, Atul Kumar wrote:
Hi,
When I m creating a test db user using below command using root OS user
sudo -u postgres createuser -p 5432 --pwprompt testuser
I am getting the attached error of port.
But my postgres services are
issues. See Tom's response also.
Please re-check the same.
Regards
Atul
On Tuesday, December 1, 2020, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 12/1/20 12:51 AM, Atul Kumar wrote:
Hi,
When I m creating a test db user using below comm
get your Postgres code/packages from?
Regards,
Atul
Adrian Klaver
adrian.kla...@aklaver.com
://www.sqlshack.com/the-halloween-problem-in-sql-server-and-suggested-solutions/
And what are the consequences if you do it nevertheless.
--
Adrian Klaver
adrian.kla...@aklaver.com
27;/usr/lib/postgresql/9.6/bin/psql -p5432'
--
Angular momentum makes the world go 'round.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/2/20 4:38 PM, Ron wrote:
On 12/2/20 6:21 PM, Adrian Klaver wrote:
On 12/2/20 4:13 PM, Ron wrote:
On 12/2/20 6:08 PM, David G. Johnston wrote:
On Wed, Dec 2, 2020 at 5:06 PM Ron <mailto:ronljohnso...@gmail.com>> wrote:
That you were comparing apples and oranges - specifically
- #*Listen address* =*'*' *) in
config file. But still my colleague is not able to connect it. Kindly
provide some guidance on this.
Regards
Muthu
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/4/20 8:03 AM, Paul Förster wrote:
Hi Adrian,
On 04. Dec, 2020, at 16:13, Adrian Klaver wrote:
That is the wrong file, the *.sample is the giveaway.
hmmm, I'd rather call it essential reference documentation or template for
automation. It's perfectly well suited to automatic
be made because the target machine
actively refused it.
Regards
Muthu
On Sat, Dec 5, 2020 at 1:36 AM Nicklas Avén <mailto:nicklas.a...@jordogskog.no>> wrote:
On 4 December 2020 17:17:48 CET, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
>On 1
tgres=# select pg_reload_conf();
You can then see the effective result immediately in pg_hab_file_rules:
postgres=# table pg_hba_file_rules;
Hope this helps.
Given that the OP changed pg_hba.conf.sample, probably not:).
Cheers,
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
would likely a couple of years before it would be included, so that is
not going to help you. What is your concern?
Thanks,
*—*
*Zé Rui Marques*
--
Adrian Klaver
adrian.kla...@aklaver.com
so that is
not going to help you. What is your concern?
>
> Thanks,
> *—*
> *Zé Rui Marques*
>
>
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/7/20 8:16 AM, Rob Sargent wrote:
On 12/7/20 8:25 AM, Adrian Klaver wrote:
On 12/7/20 7:18 AM, Hemil Ruparel wrote:
I want to say this. I never liked any extension language. It's like
Java is not meant to interact with databases.
The JDBC folks might disagree.
That interacti
;*
*
*
*
*
Appreciate your help, thank you !!*
*
--
Adrian Klaver
adrian.kla...@aklaver.com
DEFERRABLE INITIALLY DEFERRED from the start, it should
work --- at least it does for me.
That worked.
--
Adrian Klaver
adrian.kla...@aklaver.com
g. of values in numeric type column
data_numeric
--
{2.0}
{1.0}
Regards
Prabhjot
--
Adrian Klaver
adrian.kla...@aklaver.com
arrays?
4) If 3) then what about missing data?
(4 rows)
Regards
--
Adrian Klaver
adrian.kla...@aklaver.com
xact Postgres 13 version?
Hardware specifications for machine?
Changes in this
section(https://www.postgresql.org/docs/13/runtime-config-resource.html)
of postgresql.conf?
Relevant information from system logs?
--
Adrian Klaver
adrian.kla...@aklaver.com
(https://sqitch.org/). It will organize the process of schema
creation and management.
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
QL server log; there were no relevant messages in
journalctl.
What is the exact command you are using to do the restore?
--
Adrian Klaver
adrian.kla...@aklaver.com
/13/20 6:34 PM, Adrian Klaver wrote:
> On 12/12/20 6:58 PM, Tim Uckun wrote:
>> I want to dump my postgres schema to disk in neat directories like
>> pgadmin presents. Then I want to be able to edit the files and sync
>> changes to the database and ideally
your previous post. Namely, use for
development and experimentation. In addition once you have done the
preceding can then roll out to production.
--
Adrian Klaver
adrian.kla...@aklaver.com
ors.html
42.7.2. Opening Cursors
For why OPEN is plpgsql specific and how to use it.
Regards
Muthukumar.gk
--
Adrian Klaver
adrian.kla...@aklaver.com
didn’t delete the file.
Can you let us know if anyone has observed the file getting deleted upon
abrupt shutdown of Windows?
What is causing the shutdown?
Thanks,
Joel
--
Adrian Klaver
adrian.kla...@aklaver.com
b
--wal-segsize=16 -D /hostname/pg/NewInstance/data"?
Well the default is 16MB so you should not have to set it.
What does:
pg_controldata -D <11.5 data dir>
pg_controldata -D <12.1 data dir>
show for the setting Bytes per WAL segment: ?
--
Adrian Klaver
adrian.kla...@aklaver.com
usr/pgsql-13/lib/
every version has the same issue with packages, please help me to
resolve this issue.
--
Adrian Klaver
adrian.kla...@aklaver.com
/hostname/pg/NewInstance/data"?
>
Well the default is 16MB so you should not have to set it.
What does:
pg_controldata -D <11.5 data dir>
pg_controldata -D <12.1 data dir>
show for the setting Bytes per WAL segment: ?
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto
packages?
--
Adrian Klaver
adrian.kla...@aklaver.com
These changes will appear in next minor updates.
"
Have you looked at this announcement?:
https://yum.postgresql.org/news/new-repo-rpms-released/
On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 12/19/20 4:53 PM, Rambabu V wrote:
e did some sanity checks before we switched to the new master, like
comparing max(id) to see if the replica was up to date (including
this table) and counts on some smaller tables and that all checked
out okay, we never thought of missing rows somewhere in between
So how can th
like:
ERROR: requested WAL segment 000101F1001D has already
been removed
What was being run when the above ERROR was triggered?
Regards,
Lars
On Sun, Dec 20, 2020 at 6:58 PM Adrian Klaver
--
Adrian Klaver
adrian.kla...@aklaver.com
plication running on the 11 instance?
In any case what was the command logged just before the ERROR.
Lars
--
Adrian Klaver
adrian.kla...@aklaver.com
oints are occurring too
frequently (20 seconds apart)
2020-12-10 13:26:43 UTC::@:[5537]:HINT: Consider increasing the
configuration parameter "max_wal_size".
2020-12-10 13:26:43 UTC::@:[5537]:LOG: checkpoint starting: wal
Lars
On Mon, Dec 21, 2020 at 11:51 PM Adrian Klaver
mailto:adrian
om information_schema.tables;
ERROR: invalid name syntax
SELECT pg_table_size(table_name::regclass) from information_schema.tables;
ERROR: invalid name syntax
SELECT table_name::text::regclass from information_schema.tables;
ERROR: invalid name syntax
So how does one go about using a table name
On 12/22/20 4:33 PM, David G. Johnston wrote:
On Tue, Dec 22, 2020 at 5:08 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
SELECT pg_table_size(table_name::regclass) from
information_schema.tables;
ERROR: invalid name syntax
So how does one go about usin
On 12/22/20 4:39 PM, Tom Lane wrote:
Adrian Klaver writes:
So how does one go about using a table name from
information_schema.tables in pg_table_size()?
You want something like
select pg_table_size(quote_ident(table_schema)||'.'||quote_ident(table_name))
from information_sch
On 12/22/20 11:21 PM, Laurenz Albe wrote:
On Tue, 2020-12-22 at 16:07 -0800, Adrian Klaver wrote:
This came up in this SO question:
https://stackoverflow.com/questions/65416748/postgres-12-4-gives-function-does-not-exists-error
Where the query is:
SELECT (TABLE_SCHEMA || '"."
educe the parts count by not running the binary 12 --> 12 replication
at the same time you are doing the 11 --> 12 logical replication.
--
Adrian Klaver
adrian.kla...@aklaver.com
_VM9LhYPeu%2BUw__gEVvrBffGL%3DFO-88cZEp-35%2BarA%40mail.gmail.com
Lars
On Thu, Dec 24, 2020 at 5:52 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 12/23/20 1:40 AM, Lars Vonk wrote:
> The full setup is:
>
> **Before:
> 11
Or - is it possible to check for this in the trigger-function?
As David Johnson mentioned you can check whether the value for the
column is changed:
NEW.animal <> OLD.animal
--
*Andreas Joseph Krogh*
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...
On 12/25/20 10:19 AM, Andreas Joseph Krogh wrote:
På fredag 25. desember 2020 kl. 17:48:39, skrev Adrian Klaver
mailto:adrian.kla...@aklaver.com>>:
On 12/25/20 5:52 AM, Andreas Joseph Krogh wrote:
> Hi.
> I need to set a value in a trigger if a column is ex
= '/bin/true/' # command to use to archive a
logfile segment
So please help me in giving the reason of it that even after reloading
the conf file why it didn't set the value in postgresql.conf file ?
Regards,
Atul
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/28/20 10:34 PM, Muthukumar.GK wrote:
Pleas do not top post, the style on this list is bottom/inline posting.
Hi Adrian Klaver,
Sorry for typo mistake. Instead of writing lengthy query, I had written
it simple. Actually my main concept is to bring result set with multiple
rows (using
PLPGSQL-STATEMENTS-EXECUTING-DYN>.
On Tue, Dec 29, 2020 at 11:40 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 12/28/20 10:34 PM, Muthukumar.GK wrote:
Pleas do not top post, the style on this list is bottom/inline posting.
> Hi Adrian Klaver,
&
that to do?
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
oftware Developer
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk.m...@mikatiming.de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
--
Adrian Klaver
adrian.kla...@aklaver.com
V_COUNT smallint;
C_SCHEMAvarchar := CURRENT_SCHEMA;
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/3/21 10:27 AM, Thiemo Kellner wrote:
Quoting Adrian Klaver :
Well, I guess, I can put the correct schema at installation, but
would have liked to have a more general approach. Furthermore, I
think this also implies that installation can only be done by psql. :-s
Why not grab the
On 1/3/21 11:19 AM, Thiemo Kellner wrote:
Quoting Adrian Klaver :
Can you provide an outline form of what you are trying to accomplish?
Hm, making myself understood. ;-) So from the very beginning.
There is the concept of growing degree days
Familiar with it, I have worked in farming
DB_ROUTINE_NAME ||
'" could not be found in schema "' ||
TG_TABLE_SCHEMA || '!',
hint = 'Install the routine beforehand.';
end if;
return NEW; -- If NULL was returned, the ro
ell. It's weird PostgreSQL is not doing it.
Regards,
Ingolf
*Verizon Deutschland GmbH* - Sebrathweg 20, 44149 Dortmund, Germany -
Amtsgericht Dortmund, HRB 14952 - Geschäftsführer: Detlef Eppig -
Vorsitzender des Aufsichtsrats: Francesco de Maio
--
Adrian Klaver
adrian.kla...@aklaver.com
tps://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
--
Adrian Klaver
adrian.kla...@aklaver.com
ould choose a single
problematic query and show the schema, query, and explain results,
hopefully both good and bad, and comment on how analyze seems to
affect the plan choice. But for the general question about
overcoming our statistics limitations the analyze point is not relevant.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/15/21 8:44 AM, Atul Kumar wrote:
Yes you are right. And it seems for those that ignore queries to answer.
I am not following what you are trying to say above?
Your mates have already said that they ignore answering repeated questions.
--
Adrian Klaver
adrian.kla...@aklaver.com
k you,
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
pen, we don't live in a
perfect world.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/15/21 11:54 AM, Adrian Klaver wrote:
On 1/15/21 10:49 AM, Alexander Stoddard wrote:
Please reply to list also.
Ccing list.
So to be clear, the process imports the data, then you run a query
and
it completes in x time, you then ANALYZE the same data and it runs
in y
time
/professional_support/
And I have no doubt that you will waste more time of yours as well as of
us by giving some kore excuses.
This post marks the end of my wasting your time.
--
Adrian Klaver
adrian.kla...@aklaver.com
ed only for
the use of the addressee. Unauthorized use, disclosure, distribution or
copying is strictly prohibited and may be unlawful. If you have received
this communication in error, please notify the sender immediately.
--
Adrian Klaver
adrian.kla...@aklaver.com
1990's had it right. But
then, who knows about that anymore.
I think, an automatic conversion of incoming posts to plain text and dropping
all non plain text attachments would help a lot already.
Cheers,
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
lds
Reply All is used so the folks involved in the conversation get the
emails in a timely manner even if the mail server is running slow
delivering to everyone else.
...
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
otepad and split in 2 files and run after other it works fine.
Split where?
Is this function being used in a TRIGGER on esp_altera_estoque?
--
Att
Márcio A. Sepp
--
Adrian Klaver
adrian.kla...@aklaver.com
uot;/var/run/postgresql" at port "5432".
16. pguser=> select 5.0/99;
17. ?column?
18.
19. 0.05050505050505050505
20. (1 row)
--
Adrian Klaver
adrian.kla...@aklaver.com
::1/128 md5
So to the questions:
1. Am I already getting encrypted connections and if so, how?
2. In production I hope to name the role with each connection as I want
the search_path set by the connecting role. Will I need a cert per role
with CN=?
--
Adrian Klaver
adrian.kla...@aklaver.com
this:
https://www.postgresql.org/docs/12/auth-cert.html
"User name mapping can be used to allow cn to be different from the
database user name."
which leads to this:
https://www.postgresql.org/docs/12/auth-username-maps.html
--
Adrian Klaver
adrian.kla...@aklaver.com
is some sort of security. Just wondering if there is
provision made for people who know how to do SET search_path or \dn or
schema qualify objects?
--
Adrian Klaver
adrian.kla...@aklaver.com
Yes, I'm confused. As I said in reply to Jeff, I would rather not need
to remember to set the search_path, which I can avoid if I login as "role".
I have not seen that conversation and I do not see it in the archive
either. Is that off-list, different thread, something el
r_depth() < 1)
EXECUTE FUNCTION log_last_chaged();
Regards,
HS
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/23/21 10:20 AM, Condor wrote:
On 23-01-2021 18:31, Adrian Klaver wrote:
On 1/23/21 4:57 AM, Condor wrote:
So do an UPDATE and the RETURN NULL to cancel the INSERT. Untested
example:
UPDATE arhive_table SET sendto = 0, uts = date_part('epoch',
CURRENT_TIMESTAMP)::int
Robert
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/23/21 12:14 PM, Condor wrote:
On 23-01-2021 20:49, Adrian Klaver wrote:
On 1/23/21 10:20 AM, Condor wrote:
Sorry,
I'm sorry, I don't understand something. You mean to do pure INSERT ON
CONFLICT DO or to modify the trigger ?
No I meant that in the external program you us
using psycopg2.
--
Adrian Klaver
adrian.kla...@aklaver.com
psycopg2.
--
Adrian Klaver
adrian.kla...@aklaver.com
he large objects are for.
How to find and delete all large objects in database ? Maybe it is
created accidently .
Using
PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu,
compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
s and many thousands of tables.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
is lomowner. Use that oid to find the role that owns the objects here:
https://www.postgresql.org/docs/12/view-pg-roles.html
select rolname from pg_roles where oid = ;
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
objects?
How to use this information to fix the issue ?
Do the pg_dump as user clusteradmin.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
do this ?
Short term grant the dump user permissions on the large objects.
Long term figure out what they are and if they are needed or not.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
n first of them: 200936761
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
s bytea columns instead.
How to figure out what is this large object ?
You could try some of the functions here:
https://www.postgresql.org/docs/12/lo-funcs.html
to see if you can figure it out.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
.
What happens if you query:
https://www.postgresql.org/docs/12/catalog-pg-largeobject.html
as a superuser?
Do you see anything in the data field?
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
ist:
https://www.postgresql.org/list/pgsql-odbc/
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
create tablespaces nor select tablespaces
for objects. With this option, all objects will be created in whichever
tablespace is the default during restore.
This would have to be done when the pg_dumpall is run.
thank you
Joao
--
Adrian Klaver
adrian.kla...@aklaver.com
e I worked with ODBC so I would confirm on the -odbc list.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
pable to CREATE / DROP
another user? or a user that might allowed to do anything?
Thank you
Joao
--
Adrian Klaver
adrian.kla...@aklaver.com
t would be attributing AI abilities to pg_dumpall that it does not
have. Those commands got there from someone in the original database
tinkering with grants.
--
Adrian Klaver
adrian.kla...@aklaver.com
src/include/pg_config_manual.h."
Thank you
Joao
--
Adrian Klaver
adrian.kla...@aklaver.com
m.bad-guc";
ERROR: unrecognized configuration parameter "custom.bad-guc"
I know I can simply not use dashes in names, but if I can *set* it, how
can I get the value back?
The only way I found so far is:
select setconfig[array_position(setconfig, 'custom.bad-guc=1a')] from
pg_db_role_setting where setrole = 'aklaver'::regrole;
setconfig
---
custom.bad-guc=1a
depesz
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/9/21 7:45 AM, hubert depesz lubaczewski wrote:
On Tue, Feb 09, 2021 at 07:41:02AM -0800, Adrian Klaver wrote:
The only way I found so far is:
select setconfig[array_position(setconfig, 'custom.bad-guc=1a')] from
pg_db_role_setting where setrole = 'aklaver'::regrole;
On 2/9/21 9:00 AM, Tom Lane wrote:
Adrian Klaver writes:
On 2/9/21 7:45 AM, hubert depesz lubaczewski wrote:
but I find it curious that I can set the guc using normal-ish SET, but
can't get it using SHOW or even select current_setting()
Yeah, I think that part is a bug report.
1901 - 2000 of 4934 matches
Mail list logo
