og
This seems impossible to me.
What does ps ax | grep post show?
--
Adrian Klaver
adrian.kla...@aklaver.com
I ask because I have a cron job that does a pg_dumpall each night at 11:30
pm. (It's a small installation for my business use so the files are not
excessive and I keep them for only short periods.)
Regards,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
something that has been considered for implementation?
An alternative?:
https://www.postgresql.org/message-id/ABA5562F-56A9-4AB1-95D6-398215015DBD%40gmail.com
Thanks in advance,
Chloe
--
Adrian Klaver
adrian.kla...@aklaver.com
id, text from TEST';
drop table tmp1;
RETURN QUERY
EXECUTE mysql;
END;
$function$
select * from testdyn(1);
id | text
----+---
1 | test1
2 | test2
--
Adrian Klaver
adrian.kla...@aklaver.com
or a migration today.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
!
--
Adrian Klaver
adrian.kla...@aklaver.com
urces/pglogical/pglogical-docs/).
The forerunner to the built in logical replication in 10+.
*From:* Adrian Klaver
*Sent:* Friday, December 6, 2019 1:32 PM
*To:* Julie Nishimura ;
pgsql-general@lists.postgresql.org ;
e" on the popup.
You are going to need to provide more information:
1) What application(and version) are you using above?
2) Postgres version?
3) OS and version?
--
Adrian Klaver
adrian.kla...@aklaver.com
View/Edit Data. The Save you are looking for is next to
it(Grid with down arrow). Also available using F6. It becomes active
when you make a change in the data grid.
On Sun, 8 Dec 2019 at 15:09, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 12/8/19 11:54 AM, Patr
talls in
the V11 location.
Lets first see what you have for a 12 install before tackling that.
What do I need to do to get the V12 server package correctly installed?
Thanks, in advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
cussion. All of this is the
long way of saying I doubt anyone will want to go down this path again.
--
Adrian Klaver
adrian.kla...@aklaver.com
lso uses the
environment variables supported by libpq (see Section 33.14).
"
https://www.postgresql.org/docs/12/libpq-envars.html
"
PGUSER behaves the same as the user connection parameter.
"
Seems to me this is something that you need to bring up with the Brew
maintainers
e, it is an error to specify an explicit value
(other than DEFAULT) for an identity column defined as GENERATED ALWAYS.
This clause overrides that restriction.
"
--
Adrian Klaver
adrian.kla...@aklaver.com
/postgresql start fails
How did you install Postgres 12?
Why are you using the file in init.d/ instead of pg_ctlcluster?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/10/19 8:24 AM, stan wrote:
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
On 10/12/2019 16:11, Adrian Klaver wrote:
On 12/10/19 7:32 AM, stan wrote:
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
Hi Stan
Check security make sure V12 postgres?? has the co
On 12/10/19 9:03 AM, stan wrote:
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
On 10/12/2019 16:11, Adrian Klaver wrote:
On 12/10/19 7:32 AM, stan wrote:
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
Hi Stan
Check security make sure V12 postgres?? has the co
On 12/10/19 8:14 AM, stan wrote:
On Tue, Dec 10, 2019 at 07:46:02AM -0800, Adrian Klaver wrote:
On 12/10/19 3:21 AM, stan wrote:
I upgraded successfully on our test machine from V11 to V12 the other day.
The below indicates that this is not the case.
Now it is time to upgrade the
ull display is "NULL".
psql (12.1)
Type "help" for help.
postgres=# \du
List of roles
Role name | Attributes
| Member of
---++---
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS
| {}
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/11/19 9:06 AM, Tom Lane wrote:
Adrian Klaver writes:
On 12/11/19 5:18 AM, Олег Самойлов wrote:
This utility, like most other PostgreSQL utilities, also uses the environment
variables supported by libpq (see Section 33.14).
https://www.postgresql.org/docs/12/libpq-envars.html
PGUSER
*
--
Adrian Klaver
adrian.kla...@aklaver.com
Danny
--
Adrian Klaver
adrian.kla...@aklaver.com
ce as to what I can do is appreciated.
--
Adrian Klaver
adrian.kla...@aklaver.com
t, but as row locks are released at the end of a
transaction (according to the docs) then my expectation was for the unlocking and the
visibility of newly committed rows to be atomic.
I've tried FOR NO KEY UPDATE too, without luck.
If I'm doing something forbidden (and the docs s
types being used.
Thanks for any direction.
--
Adrian Klaver
adrian.kla...@aklaver.com
24.3,
33, 0, 1, NULL, NULL, E'1', E'A', NULL,
E'A1', NULL, 23, NULL, '2012-10-18 00:00:00', 55 );
--
Angular momentum makes the world go 'round.
--
Adrian Klaver
adrian.kla...@aklaver.com
| 20
(2 rows)
testNTB=> select * from ty_yid_seq;
last_value | log_cnt | is_called
+-+---
1 | 32 | t
(1 row)
testNTB=> INSERT INTO ty VALUES (DEFAULT, 30);
ERROR: duplicate key value violates unique constraint "ty_pkey"
DETAIL: Key (yid)=(2) already exists.
--
Adrian Klaver
adrian.kla...@aklaver.com
be easier to figure out if you outline what is going on:
1) The purpose of the migration?
2) A general sense of what the application is and what it does.
3) Have you looked at the Relations tab in Access to see what if any
relationships are there?
Ross
--
Adrian Klaver
adrian.kla...@aklaver.com
p
drwx-- 3 postgres postgres 4096 Dec 18 15:56 pg_xlog
drwx-- 4 postgres postgres 4096 Dec 18 16:31 pg_logical
postgres@4ed92bac84af:/var/lib/postgresql/9.5/main$
ident.conf
Please advise.
Thanks,
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/21/19 6:40 PM, Boylan, Ross wrote:
From: Adrian Klaver
Sent: Saturday, December 21, 2019 3:37 PM
This might be easier to figure out if you outline what is going on:
Since I seem to have gone on in my responses, let me do one-line answers before
the fuller ones.
1) The purpose of
On 12/22/19 11:59 AM, Boylan, Ross wrote:
From: Adrian Klaver
> Sent: Sunday, December 22, 2019 10:35 AM
.
Alright this is the part where I got confused. I think what is going on is:
1) The immediate change is going to be to Access 2016 on Windows 10 64
keeping the data in Acc
Don't know how you would do that for the internal Access side of things.
Ross
--
Adrian Klaver
adrian.kla...@aklaver.com
t;CREATE object", not
when pg_dump, pg_basebackup and pg_update ran.
Likewise, modification time is when we last ran an ALTER command ran,
not when VACUUM ran (that's tracked elsewhere) or DML ran.
That's all.
--
Angular momentum makes the world go 'round.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/24/19 8:44 AM, Ron wrote:
On 12/24/19 10:39 AM, Adrian Klaver wrote:
On 12/23/19 6:14 PM, Ron wrote:
On 12/23/19 7:01 PM, Bruce Momjian wrote:
Is this something that has been considered for implementation?
I wrote a blog about this:
https://momjian.us/main/blogs/pgblog/2017.html
-terms-of-service*
--
Adrian Klaver
adrian.kla...@aklaver.com
htly different, but can I get the new
key into the NEW structure to return from the function call?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/25/19 11:08 AM, stan wrote:
On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
On 12/25/19 7:26 AM, stan wrote:
I am writing a trigger/function to make certain a default item, and its key
exist when an insert is called. EG
The trigger gets called on insert to T1 If column
On 12/25/19 12:39 PM, stan wrote:
On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
On 12/25/19 11:08 AM, stan wrote:
On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
On 12/25/19 7:26 AM, stan wrote:
I am writing a trigger/function to make certain a default item
categories and then project specific
No, my nose is twitching also.
expenditures use the category id?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/25/19 3:09 PM, stan wrote:
On Wed, Dec 25, 2019 at 02:34:43PM -0800, Adrian Klaver wrote:
On 12/25/19 12:39 PM, stan wrote:
Other approaches have been suggested, e.g. use a traditional FK
relationship. The big unknown in you present system is what:
SELECT cost_category_key from t2
On 12/31/19 4:41 AM, Sonam Sharma wrote:
How to grant table import access in postgres ?
Define import.
--
Adrian Klaver
adrian.kla...@aklaver.com
HEMA utility;
I ask because the docs:
https://www.postgresql.org/docs/12/app-pgdump.html
"Dump only schemas matching pattern; this selects both the schema
itself, and all its contained objects. "
support the idea that the schema definition is dumped.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
In pgrestore_utility.sql there is no CREATE SCHEMA.
This came up in a previous thread:
https://www.postgresql.org/message-id/6234.1569941612%40sss.pgh.pa.us
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/2/20 9:04 AM, Sonam Sharma wrote:
Thanks Adrian, it worked :)
What worked?
Still not clear what was not working in the first place?
On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 1/2/20 5:47 AM, Tom Lane wrote:
>
On 1/4/20 3:54 AM, Paula Kirsch wrote:
I'm just trying to understand the trade-offs between sending everything
always as text, all integer parameters as binary, floats as binary, etc.
From where to where and using what?
--
Adrian Klaver
adrian.kla...@aklaver.com
ations.html#GUC-DATA-DIRECTORY
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/4/20 8:27 AM, Rich Shepard wrote:
On Sat, 4 Jan 2020, Adrian Klaver wrote:
Not following above:
1) Are you looking for your current postgresql.conf?
Yes
I don't see anything here:
https://slackbuilds.org/slackbuilds/14.2/system/postgresql/rc.postgresql.new
that changes the
parameters.
https://www.postgresql.org/docs/11/catalog-pg-type.html
Any suggestions or examples of parse-messages with a couple of
parameters being passed would be appreciated.
Thank you.
On Sat, Jan 4, 2020 at 11:18 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 1/
se libpq is currently
all-or-nothing about result type formats, and if you start using
extension types then not all of them even _have_ a binary
format. And to
decode a binary result you need to know the type, and have code to
handle every specific type
Institute - UAF
2156 Koyukuk Drive
Fairbanks AK 99775-7320
Work: 907-474-5172
cell: 907-328-9145
--
Adrian Klaver
adrian.kla...@aklaver.com
change_table where existing_table.pk = change_table.id;
---
Israel Brewster
Software Engineer
Alaska Volcano Observatory
Geophysical Institute - UAF
2156 Koyukuk Drive
Fairbanks AK 99775-7320
Work: 907-474-5172
cell: 907-328-9145
--
Adrian Klaver
adrian.kla...@aklaver.com
tute - UAF
2156 Koyukuk Drive
Fairbanks AK 99775-7320
Work: 907-474-5172
cell: 907-328-9145
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/7/20 1:10 PM, Israel Brewster wrote:
On Jan 7, 2020, at 12:01 PM, Adrian Klaver wrote:
On 1/7/20 12:47 PM, Israel Brewster wrote:
One potential issue I just thought of with this approach: disk space. Will I be
doubling the amount of space used while both tables exist? If so, that
On 1/7/20 1:43 PM, Israel Brewster wrote:
On Jan 7, 2020, at 12:21 PM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 1/7/20 1:10 PM, Israel Brewster wrote:
On Jan 7, 2020, at 12:01 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 1/7/20 12:47 PM,
is
PG::ConnectionBad: PQconsumeInput() :
rgds,
PMc
--
Adrian Klaver
adrian.kla...@aklaver.com
is?
Take it up with the maintainer?:
https://github.com/tds-fdw/tds_fdw
Thanks,
Soni.
--
Adrian Klaver
adrian.kla...@aklaver.com
ct that the database is being replicated would prevent the needed
steps from occurring as it's my understanding that you can't drop a table
that's being replicated between two instances.
Why not use VACUUM?
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-
d up needed by the OS or other programs?
Otherwise VACUUM will mark it as reusable by the database.
4) What are the size of the tables and the deletion churn rate?
--
Adrian Klaver
adrian.kla...@aklaver.com
file
"/usr/pgsql-11/share/extension/pg_stat_statements.control": No such file
or directory
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
20150623 (Red Hat 4.8.5-36), 64-bit
How did the above get installed, from source, RPM. other?
Thanks.
*
*
Rushikesh Socha
Edison,NJ,USA
Cell : +1 860 794 4643
On Mon, Jan 13, 2020 at 2:24 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 1/13/20 11:15 AM, Rushikesh so
---
...
public | allowed_peer_ip | table | postgres
...
public | turn_secret | table | postgres
You are connecting as user turn and trying to access tables owned by
user postgres.
How to solve the problem?
Marco
--
Adrian Klaver
adrian.kla...@aklaver.com
ocs/12/app-postgres.html#APP-POSTGRES-SINGLE-USER
Thanks in advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
repos):
https://www.postgresql.org/download/linux/ubuntu/
https://wiki.postgresql.org/wiki/Apt
Best Regards,
Kasun Kulathunga
--
Adrian Klaver
adrian.kla...@aklaver.com
https://www.postgresql.org/docs/12/sql-insert.html
Look for
ON CONFLICT Clause
Though I don't think this is what you need at this point.
Regards
Werner
--
Adrian Klaver
adrian.kla...@aklaver.com
ed as an unsigned four-byte integer. "
I am pretty sure this:
c.oid::bigint
is the problem.
--
Adrian Klaver
adrian.kla...@aklaver.com
$$BEGINIFi<0THENRETURNi
+1;ELSEGOTOlabel1;ENDIF<>RETURNnull;END;$$LANGUAGE plpgsql;|
Are you looking for EXIT?:
https://www.postgresql.org/docs/12/plpgsql-control-structures.html#PLPGSQL-CONDITIONALS
42.6.5.2. EXIT
--
Adrian Klaver
adrian.kla...@aklaver.com
. Both are
implemented with a sequence.
--set sequence to max ID on a table
select setval( 'table_name_id_seq', ( select max(id) + 1 from
table_name ) );
--
Adrian Klaver
adrian.kla...@aklaver.com
the table is first created (before any
data is added)
* At least one user reports that he has recently migrated his database
from one server to another via a `pg_dump -C` and later piping into psql.
--
Adrian Klaver
adrian.kla...@aklaver.com
ld lead to this problem. Am I naive?
In psql who does:
\l the_database_name
show?
To answer Adrian's question: the lengths of the values in the indexed
columns are identical between the duplicated rows.
--
Adrian Klaver
adrian.kla...@aklaver.com
they are a lot easier to understand and implement.
Sorry for such a newbie question.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/19/20 2:32 AM, stan wrote:
Please post to list also.
Ccing list.
On Sat, Jan 18, 2020 at 08:56:06AM -0800, Adrian Klaver wrote:
On 1/18/20 8:53 AM, stan wrote:
So, I just discovered the rules system. As I understand it, it can be used
to rewrite queries before they are passed to the
you time.
Best,
Tanja
--
Adrian Klaver
adrian.kla...@aklaver.com
sisis123sisis');
md5
--
2f128a1fbbecc4b16462e8fc8dda5cd5
Thanks
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
:
https://doxygen.postgresql.org/src_2common_2md5_8c.html#ad1cda4632643f79bbb60f0466fec0e41
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
ance of good people saying use a later
version and do a major upgrade that is not currently
possible/feasible).
Grateful for any detailed advice on the correct path for the above.
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
me TYPE text;
LOG: statement: ALTER TABLE t1 ALTER COLUMN name TYPE text;
DEBUG: building index "pg_toast_37609_index" on table "pg_toast_37609"
serially
ALTER TABLE
Thanks!
Mike
**
--
Adrian Klaver
adrian.kla...@aklaver.com
this auxiliary table.
DEBUG: building index "pg_toast_37609_index" on table "pg_toast_37609"
Thanks for the feedback. I really appreciate it and it's super
interesting to learn about.
Mike
--
Adrian Klaver
adrian.kla...@aklaver.com
o text you are not
really changing type, just the type oid. I tried searching the source
for confirmation of this to no avail. A definitive answer is going to
need come from someone with more knowledge of the internals.
--
Adrian Klaver
adrian.kla...@aklaver.com
ld suggest you to try
it once.
Kindly let us know if it fixed for you."
There was no response from the issue submitter so I assume the above worked.
BR,
Tanja
--
Adrian Klaver
adrian.kla...@aklaver.com
am being pressured to complete this work today.
(While understanding that is not how it works ...)
Phil
On Thu, 23 Jan 2020 at 15:46, Adrian Klaver wrote:
On 1/23/20 3:28 AM, Phil Fisher wrote:
Hello
I have a 9.6.6 system that misses some features. It is installed on a
RHEL7 OS. Reading
restart it there was
a failure message. I am not sure if that was an artefact from moving
from 9.6.6 to 9.6.16 or not but I mention it in case someone has a
similar issue when starting up after the "upgrade".
Phil
On Thu, 23 Jan 2020 at 15:46, Adrian Klaver wrote:
On 1/23/20 3:28 AM, P
QL state: 22023
Try GMT:
test_(postgres)# select CURRENT_TIMESTAMP AT TIME ZONE 'GMT';
timezone
2020-01-24 17:17:52.754861
For list of recognized abbreviations:
https://www.postgresql.org/docs/11/view-pg-timezone-abbrevs.html
Postgres -:11.2
On 1/24/20 9:19 AM, Adrian Klaver wrote:
On 1/24/20 8:59 AM, nikhil raj wrote:
Hi ALL,
Required help with the time zone. i am getting error on the GST time
line. is tht a bug or postgres doesn't support the GST time zone.
select CURRENT_TIMESTAMP AT TIME ZONE 'GST'
ERROR:
think?
Thanks for any help or guidance!
See:
https://www.postgresql.org/docs/12/app-psql.html
Meta-Commands
-m
--
Adrian Klaver
adrian.kla...@aklaver.com
but which i insert into the databases is showing empty column.
On Fri, Jan 24, 2020 at 11:09 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 1/24/20 9:19 AM, Adrian Klaver wrote:
> On 1/24/20 8:59 AM, nikhil raj wrote:
>> Hi ALL,
>>
>
fixed IP addresses. In night they are not used
by users, can stopped during move.
Should I download .backup files and use pg_restore or use pipe to
restore whole cluster.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
tore process ?
Will turning fsync off during restore speed up it ?
New server has 11 GB ram . No other applications are running during
database transfer.
shared_buffer=1GB setting is currently used in postgresql.conf
5. Can this plan improved
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
mitter so I assume the above worked.
BR,
Tanja
--
Adrian Klaver
adrian.kla...@aklaver.com
there will be hopefully no
dependencies.
Roles are global, dependencies can be local to a database. The issue is
if objects in a restored database depend on roles that no longer exist
in the global context.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
tables?
Thanks
Raj
--
Adrian Klaver
adrian.kla...@aklaver.com
ained by or contains
the right operand and false otherwise would solve this, I am just
wondering if there is a more elegant and economical way to express this.
(besides writing a trigger which is always an option).|
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Adrian Klaver
the amount of information you've given.
Yes, turning off enable_seqscan is a bad idea in general, but why
you got a worse plan without that requires details.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
add col
2. set default
3. updates
---
TR. COMMIT
Or it isn't help me?
Because the whole transaction locks the other users also, just like
"alter add colum wit hdefault statement"?
Thank you for your and help!
Best regards
dd
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/30/20 3:46 AM, Achilleas Mantzios wrote:
On 29/1/20 8:32 μ.μ., Adrian Klaver wrote:
On 1/29/20 8:12 AM, Achilleas Mantzios wrote:
Hello Dear Postgresql ppl,
I have a table with date ranges and need to express the following
constraint : allow overlaps only if there is complete containment
:
https://www.postgresql.org/docs/12/postgres-fdw.html#id-1.11.7.42.10
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
ause it´s using pg_catalog schema. The only way
to solve this is defining search_path when starting all triggers ?
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
y got it. Unfortunately that does not mean I have solution.
--
Adrian Klaver
adrian.kla...@aklaver.com
f it exists ?
Should I invoke
drop database if exists
and
create database
commands before calling pg_restore or can pg_restore do it itself ?
Using Postgres 12 on Debian 10
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
n those ?
Is there some postgres or Debian setting which can used during restore time
to speed up restore ?
I use shared_buffers=1GB , other settings from debian installation.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
and fast the connection is between the
two machines.
What sort of time frame are you working with?
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
1101 - 1200 of 4934 matches
Mail list logo
