binary upgrade, set heap's relfrozenxid and relminmxid
UPDATE pg_catalog.pg_class
SET relfrozenxid = '492', relminmxid = '1'
WHERE oid = '"public"."r"'::pg_catalog.regclass;
Is it expected ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
elfilenode is preserved,
not changing after pg_upgrade.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 12/15/21 12:09 AM, tushar wrote:
I spent much of today reviewing 0001. Here's an updated version, so
far only lightly tested. Please check whether I've broken anything.
Thanks Robert, I tested from v96/12/13/v14 -> v15( with patch)
things are working fine i.e table /index r
/basebackup.c: patch does not apply
error: patch failed: src/include/replication/basebackup_sink.h:285
error: src/include/replication/basebackup_sink.h: patch does not apply
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 12/28/21 1:11 PM, Jeevan Ladhe wrote:
You need to apply Robert's v10 version patches 0002, 0003 and 0004,
before applying the lz4 patch(v8 version).
Thanks, able to apply now.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
ep
server-compression
--server-compression=none|gzip|gzip[1-9]
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
]$ ls foo1
backup_manifest base.tar.gz pg_wal.tar
if this scenario is valid then both the folders format should be in lz4
format otherwise we should
get an error something like - not a valid option ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
emoving -z option backup is in tar mode only
edb@centos7tushar bin]$ ./pg_basebackup -t server:/tmp/test0 -Xfetch
[edb@centos7tushar bin]$ ls /tmp/test0
backup_manifest base.tar
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On Tue, Dec 28, 2021 at 1:12 PM Jeevan Ladhe
wrote:
> Hi Tushar,
>
> You need to apply Robert's v10 version patches 0002, 0003 and 0004, before
> applying the lz4 patch(v8 version).
> Please let me know if you still face any issues.
>
Thanks, Jeevan.
I tested —server-c
action.
I have tested couple of scenarios of pg_basebackup / pg_receivewal
/pg_recvlogical / Publication(wal_level=logical) and
Subscription e.t.c against HEAD (with patches) and cross-version
testing. Things look good to me and no breakage was found.
--
regards,tushar
Enterpris
X.
but same able to see by firing this below query on SLAVE cluster -
SELECT * FROM pg_logical_slot_get_changes('standby_slot', NULL, NULL);
Is it expected ?
regards,
tushar
On 12/17/2018 10:46 PM, Petr Jelinek wrote:
Hi,
On 12/12/2018 21:41, Andres Freund wrote:
I don't like
INSERT: aid[integer]:65062 bid[integer]:1
abalance[integer]:0 filler[character]:' '
table public.pgbench_accounts: INSERT: aid[integer]:65063 bid[integer]:1
abalance[integer]:0 filler[character]:' '
table public.pgbench_accounts: INSERT: aid[integer]:65064 bid[integer]:1
abal
On 03/04/2019 04:54 PM, tushar wrote:
.)Perform pg_basebackup using --slot=decoding_standby with option -R
. modify port= , start the server
set primary_slot_name = 'decoding_standby' in the postgresql.conf file
of slave.
--
regards,tushar
EnterpriseDB https://www.enterp
On 03/04/2019 10:57 PM, Andres Freund wrote:
Note that hot_standby_feedback=on needs to be set on a standby, not on
the primary (although it doesn't do any harm there).
Right, This parameter was enabled on both Master and slave.
Is someone able to reproduce this issue ?
--
regards,t
rom pg_logical_slot_get_changes('m7',null,null);\n") at
postgres.c:1215
#15 0x0079d044 in PostgresMain (argc=,
argv=, dbname=0x26c9010 "postgres", username=optimized out>) at postgres.c:4256
#16 0x006874eb in main (argc=5, argv=0x26a7e20) at main.c:224
(gdb) q
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
cmax of catalog tuple
[centos@mail-arts bin]$ cat t.sql
\c regression
SELECT * from pg_create_logical_replication_slot('m61', 'test_decoding');
select * from pg_logical_slot_get_changes('m61',null,null);
regards,
On 03/04/2019 10:57 PM, Andres Freund wrote:
Hi
verLoop () at postmaster.c:1703
#25 0x008238ec in PostmasterMain (argc=3, argv=0x2ad6d00) at
postmaster.c:1376
#26 0x00748aab in main (argc=3, argv=0x2ad6d00) at main.c:228
(gdb)
regards,
On 03/07/2019 09:03 PM, tushar wrote:
There is an another issue , where i am getting error
name as c11
from
pg_catalog.pg_statistic_ext as sample_0 tablesample
system (2.7)
where cast(null as point) @ cast(null as polygon)
limit 105) as subq_0
where (true)
and ((ref_4.opfname is NULL)
and (cast(null as int8) <
: *** [test_decoding.o] Error 1
[centos@centos-cpula test_decoding]$
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 03/29/2019 06:12 PM, Robert Haas wrote:
On Fri, Mar 29, 2019 at 8:24 AM tushar wrote:
Found by one of the my colleague - Kashif Jeeshan , in PG 9.6 - make is
Kashif Jeeshan?
:-) , actually he is also working on logical replication on standbys
testing - whenever he has some bandwidth (On
On 03/29/2019 06:12 PM, Robert Haas wrote:
Kashif Jeeshan?
Ohh, Please read - Kashif Zeeshan. Sorry for the typo.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
age.
Is this expected ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
PID 20587) exited with exit code 1
Is this something already reported ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
for gist index (0001). These patches can be
applied on top of the current HEAD and make check should pass.
Regards,
While doing testing of this feature against v35- patches ( minus 004) on
Master ,
getting crash when user connect to server using single mode and try to
perform vacuum (parallel 1
On 03/13/2019 08:40 PM, tushar wrote:
Hi ,
I am getting a server crash on standby while executing
pg_logical_slot_get_changes function , please refer this scenario
Master cluster( ./initdb -D master)
set wal_level='hot_standby in master/postgresql.conf file
start the server , conne
On 04/10/2019 09:39 PM, Andres Freund wrote:
Have you reproduced this with Amit's latest version?
Yes-it is very much reproducible.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
the database system is
starting up
2019-05-27 18:55:47.425 IST [25512] FATAL: could not connect to the
primary server: FATAL: the database system is starting up
cp: cannot stat ‘pg_wal/RECOVERYHISTORY’: No such file or directory
.cp: cannot stat ‘pg_wal/RECOVERYXLOG’: No such file or direct
S.log'
postgres=#
postgres=# show log_filename ;
log_filename
-
abcd-%Y-%m-%d_%H%M%S.log
(1 row)
postgres=#
Is this an expected , if so - any work around ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
412
#16 0x0080c88e in BackendStartup (port=0x2063d00) at
postmaster.c:4084
#17 0x00808cbb in ServerLoop () at postmaster.c:1757
#18 0x00808379 in PostmasterMain (argc=3, argv=0x203aeb0) at
postmaster.c:1365
#19 0x0073d3d0 in main (argc=3, argv=0x203aeb0) at main.c:228
(gdb)
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
d | xmin | catalog_xmin | restart_lsn |
confirmed_flush_lsn
---++---++--+---+++--+--+-----+-
(0 rows)
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 02/16/2018 03:25 PM, amul sul wrote:
Attached patch proposes a required fix.
Thanks, Issue seems to be fixed with this patch , now getting an
expected error -ERROR: cannot move slot to 0/290, minimum is 0/298
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The
9 0x008ade34 in PostgresMain (argc=1, argv=0x2cd4ec0,
dbname=0x2cd4d20 "postgres", username=0x2ca5f58 "centos") at postgres.c:4144
#20 0x0080d11a in BackendRun (port=0x2cccd00) at postmaster.c:4412
#21 0x0080c88e in BackendStartup (port=0x2cccd00) at
po
doesn't go automatically
after an error ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
witch_wal());
ERROR: invalid record length at 0/2B0003C0: wanted 24, got 0
postgres=#
regards,
On 02/16/2018 04:04 PM, tushar wrote:
Hi,
Getting an another server crash against latest sources of v11 while
executing pg_replication_slot_advance second time . This issue is
also reproducible wit
descriptor
2018-03-06 13:20:24.391 GMT [14869] STATEMENT: select
pg_drop_replication_slot('p');
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
Hi,
We found that if we provide *--enable-tap-tests * switch at the time of PG
sources configuration, getting this below error
"
checking for Perl modules required for TAP tests... Can't locate IPC/Run.pm
in @INC (you may need to install the IPC::Run module) (@INC contains:
/usr/lib/perl5/site_pe
s/src/bin/pg_ctl/../../../src/test/perl
/home/runner/edbas/src/bin/pg_ctl
Do we have any better option to work without this workaround?
You could install the module via cpan :/.
Yes, will try to install.
Thanks Andres.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enter
tgres" as user "abc1".
postgres=> alter role test1 with createrole ;
ERROR: permission denied
postgres=>
which was working previously without patch.
Is this an expected behavior?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 1/19/23 3:05 PM, tushar wrote:
which was working previously without patch.
My bad, I was testing against PG v15 but this issue is not
reproducible on master (without patch).
As you mentioned- "This implements the standard idea that you can't give
permissions
you don't ha
ns the number of
connection slots. I'll create a new thread for this.
There is one typo , for the doc changes, it is mentioned
"pg_use_reserved_backends" but i think it supposed to be
"pg_use_reserved_connections"
under Table 22.1. Predefined Roles.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On Thu, Jan 19, 2023 at 6:28 PM tushar
wrote:
> On 1/19/23 2:44 AM, Nathan Bossart wrote:
> > On Wed, Jan 18, 2023 at 02:51:38PM -0500, Robert Haas wrote:
> >> Should (nfree < SuperuserReservedBackends) be using <=, or am I
> confused?
> > I believe < is corr
On 3/9/20 10:46 PM, Robert Haas wrote:
Seems like expected behavior to me. We could consider providing a more
descriptive error message, but there's now way for it to work.
Right , Error message need to be more user friendly .
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com
scenario -
postgres=# create global temp table tab1 (n int ) with (
on_commit_delete_rows='true');
CREATE TABLE
postgres=# insert into tab1 values (1);
INSERT 0 1
postgres=# select * from tab1;
n
---
(0 rows)
postgres=# alter system set max_active_global_temporary_table=0;
ALTE
On 3/12/20 8:16 PM, tushar wrote:
Seems like expected behavior to me. We could consider providing a more
descriptive error message, but there's now way for it to work.
Right , Error message need to be more user friendly .
One scenario which i feel - should error out even if -s opti
options (table_name 'ltt1');
select * from ltt1;
c1 | c2
+-
1 | gtt_c21
(1 row)
select * from l_gtt1;
ERROR: relation "l_gtt1" does not exist
LINE 1: select * from l_gtt1;
Wenjing
With Regards,
Prabhat Kumar Sahu
EnterpriseDB: http://www.enterprisedb.com <
On 3/14/20 2:04 AM, Robert Haas wrote:
OK. Done in the attached version
Thanks. Verified.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
table co;
REINDEX
Case -2
postgres=# reindex database postgres ;
WARNING: global temp table "public.co" skip reindexed
REINDEX
postgres=#
Case 2 should work as similar to Case 1.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
with clause
at same time
postgres=#
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
with new code.
This error message looks wrong to me-
postgres=# reindex table concurrently t ;
ERROR: cannot create indexes on global temporary tables using
concurrent mode
postgres=#
Better message would be-
ERROR: cannot reindex global temporary tables concurrently
--
regards,tushar
with new code.
In this below scenario, pg_dump is failing -
test=# CREATE database foo;
CREATE DATABASE
test=# \c foo
You are now connected to database "foo" as user "tushar".
foo=# CREATE GLOBAL TEMPORARY TABLE bar(c1 bigint, c2 bigserial) on
commit PRESERVE rows;
C
buffers (0.0%); 0 WAL file(s) added, 1 removed, 0 recycled; write=0.001
s, sync=0.001 s, total=0.046 s; sync files=0, longest=0.000 s,
average=0.000 s; distance=16383 kB, estimate=16383 kB
pg_basebackup: checkpoint completed
NOTICE: WAL archiving is not enabled; you must ensure that all
slave mode.
if this is not supported then I think we should throw some errors.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 1/27/22 2:15 AM, Robert Haas wrote:
The attached patch should fix this, too.
Thanks, the issues seem to be fixed now.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
/tmp/10
16384.tar.gz backup_manifest base.tar.gz
0 is for no compression so the directory should not be compressed if we
mention server-gzip:0 and both these
above scenarios should match?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
os7tushar bin]$ ls /tmp/1
backup_manifest base.tar.gz
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
directory size is 1.6GB
--compress=server-gzip:9 = compress directory size is 1.6GB
===
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On Thu, Jan 19, 2023 at 6:50 PM tushar
wrote:
> and in the error message too
>
> [edb@centos7tushar bin]$ ./psql postgres -U r2
>
> psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed:
> FATAL: remaining connection slots are reserved fo
On 1/19/23 6:28 PM, tushar wrote:
There is one typo , for the doc changes, it is mentioned
"pg_use_reserved_backends" but i think it supposed to be
"pg_use_reserved_connections"
under Table 22.1. Predefined Roles.
Thanks, this is fixed now with the latest patches
On Thu, Jan 19, 2023 at 8:34 PM Robert Haas wrote:
> On Thu, Jan 19, 2023 at 6:15 AM tushar
> wrote:
> > postgres=# create role fff with createrole;
> > CREATE ROLE
> > postgres=# create role xxx;
> > CREATE ROLE
> > postgres=# set role fff;
> > SET
>
On Mon, Jan 23, 2023 at 10:28 PM Robert Haas wrote:
>
> In previous releases, you needed to have CREATEROLE in order to be
> able to perform user management functions. In master, you still need
> CREATEROLE, and you also need ADMIN OPTION on the role. In this
> scenario, only t1 meets those requi
PROCEDURAL LANGUAGE "plspl_sm";
is this expected ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 7/8/21 9:26 PM, Robert Haas wrote:
Here at last is a new version.
Please refer this scenario ,where backup target using
--server-compression is closing the server
unexpectedly if we don't provide -no-manifest option
[tushar@localhost bin]$ ./pg_basebackup --server-compression=gzip
itdb -D d2)
run pg_upgrade with -c option ( ./pg_upgrade -d d1 -D d2 -b . -B . -c -v)
run pg_upgrade without -c option ( ./pg_upgrade -d d1 -D d2 -b . -B .)
--
--
--
Error
This behavior was not there in earlier released versions, i guess.
Is it expected behavior now onwards?
--
regards,tushar
En
On Sat, Jul 9, 2022 at 1:27 AM Robert Haas wrote:
> On Tue, Jul 5, 2022 at 8:04 AM Robert Haas wrote:
> > On Sun, Jul 3, 2022 at 1:17 PM Nathan Bossart
> wrote:
> > > If by "bolder" you mean "mark [NO]INHERIT as
> deprecated-and-to-be-removed
> > > and begin emitting WARNINGs when it and WITH I
On 7/11/22 11:01 PM, Robert Haas wrote:
Oops. Here is a rebased version of v3 which aims to fix this bug.
Thanks, Issue seems to be fixed with this patch.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
GRANTED BY "edb";
^
This issue is not reproducible on PG v16 (without patch).
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 7/19/22 12:56 AM, Robert Haas wrote:
Another good catch. Here is v5 with a fix for that problem.
Thanks, the issue is fixed now.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
and should be ignored and inherit option should
remain 'TRUE'
as it was before?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
herit
and things look good to me.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
t "test": ERROR: syntax error
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
ould not create replication slot "from_v14": ERROR: syntax error
postgres=#
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
clean setup -I am not also not able to reproduce this issue.
Thanks for checking at your end.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
;
two_phase
---
f
(1 row)
so are we silently ignoring this parameter as it is not supported on
v14RC/HEAD ? and if yes then why not we just throw an message like
ERROR: unrecognized subscription parameter: "two_phase"
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
On 9/24/21 11:57 PM, tushar wrote:
postgres=# select two_phase from pg_replication_slots where
slot_name='r105';
Correction -Please read 'r105' to 'r1015'
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
7;s';
two_phase
---
f
(1 row)
so are we silently ignoring this parameter as it is not supported on v14 ?
and if yes then why not we just throw a message like
ERROR: unrecognized subscription parameter: "two_phase"
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
t the patch then I'm not
sure why you are raising it here rather than on the thread where that
feature was developed.
Right, issue is reproducible on HEAD as well. I should have checked
that, sorry about it.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
https://www.postgresql.org/message-id/CAC6VRoY3SAFeO7kZ0EOVC6mX%3D1ZyTocaecTDTh209W20KCC_aQ%40mail.gmail.com
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
/all_data2
167M total
[edb@0 bin]$
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
ebackup to parse the archive
pg_basebackup: removing data directory "ccv"
--working
[edb@centos7tushar bin]$ ./pg_basebackup --server-compression=gzip4 -t
server:/tmp/ccv -Xnone -R --no-manifest
NOTICE: all required WAL segments have been archived
[edb@centos7tushar bin]
"--server-compression" option but not with -z or -Z ?
"-t server" with option "-z" / or (-Z )
[tushar@localhost bin]$ ./pg_basebackup -t server:/tmp/dataN -Xnone -z
--no-manifest -p 9033
pg_basebackup: error: only tar mode backups can be compressed
Try &qu
On 8/24/22 12:28 AM, Robert Haas wrote:
This patch needed to be rebased pretty extensively after commit
ce6b672e4455820a0348214be0da1a024c3f619f. Here is a new version.
Thanks, Robert, I have retested this patch with my previous scenarios
and things look good to me.
--
regards,tushar
value' |
DEFAULT }
ALTER SYSTEM RESET configuration_parameter
ALTER SYSTEM RESET ALL
How we are going to justify this in help command of ALTER SYSTEM ?
2)When i connected to postgres in a single user mode , i was not able to
set the system in read only
[edb@tushar-ldap-docker bin]$ ./postgres --sin
data start)
3.connect to psql (./psql postgres)
4.Fire query (alter system read only;)
5.shutdown the server(./pg_ctl -D data stop)
6.pg_checksums
[edb@tushar-ldap-docker bin]$ ./pg_checksums -D data
pg_checksums: error: cluster must be shut down
[edb@tushar-ldap-docker bin]$
Result - (when server
On 4/7/20 2:27 PM, 曾文旌 wrote:
Vacuum full GTT, cluster GTT is already
supported in global_temporary_table_v24-pg13.patch.
Here , it is skipping GTT
postgres=# \c foo
You are now connected to database "foo" as user "tushar".
foo=# create global temporary table g123( c1 int
server using single user mode ( ./postgres --single -D data
postgres) and create a global temp table
[tushar@localhost bin]$ ./postgres --single -D data1233 postgres
PostgreSQL stand-alone backend 13devel
backend> create global temp table t(n int);
--Press Ctl+D to exit
4)Perform ini
think it should work.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
s
REINDEX
--reindex GTT table
postgres=# REINDEX (VERBOSE) TABLE gtt;
INFO: index "gtt_pkey" was reindexed
DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
REINDEX
C)
--Reconnect to database
postgres=# \c
You are now connected to database "postgres" as user &qu
On 4/13/20 1:57 PM, 曾文旌 wrote:
[tushar@localhost bin]$ tail -20 pg_upgrade_dump_13592.log
pg_restore: error: could not execute query: ERROR: pg_type array OID value not
set when in binary upgrade mode
I found that the regular table also has this problem, I am very unfamiliar with
this part
On 4/9/20 6:26 PM, 曾文旌 wrote:
On 4/7/20 2:27 PM, 曾文旌 wrote:
Vacuum full GTT, cluster GTT is already supported in
global_temporary_table_v24-pg13.patch.
Here , it is skipping GTT
postgres=# \c foo
You are now connected to database "foo" as user "tushar".
foo=# create gl
e database ( create database x;)
connect to database x (\c x )
execute generated.sql file (\i ../../src/test/regress/sql/generated.sql)
take the dump of x db (./pg_dump -Fp x > /tmp/t.dump)
create another database (create database y;)
Connect to y db (\c y)
execute plain dump sql file (\i /tmp/t.dump
2 bytes
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
4247
#22 0x8008007e in BackendRun (port=,
port=) at postmaster.c:4437
#23 BackendStartup (port=0xa8c4dc10) at postmaster.c:4128
#24 ServerLoop () at postmaster.c:1704
#25 0x8030c89e in PostmasterMain (argc=argc@entry=3,
argv=argv@entry=0xa8c00cc0) at postmaster.c:1377
#26 0x80081
PGDG.rhel7.s390x.rpm is not signed
PG v11
Package postgresql11-libs-11.6-2PGDG.rhel7.s390x.rpm is not signed
2) Rpm packages are NOT updated . still showing 11.6 and 12.1 version
whereas latest released version is 11.7 and 12.2.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The
g asterisk , now all
the required file have been placed under llvm-toolset-7 directory and
things look fine.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
which i did
successfully [1]
postgres=!#
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
file into db2 database
You are now connected to database "db2" as user "tushar".
db2=# \i /tmp/dump.sql
SET
SET
SET
SET
SET
set_config
(1 row)
SET
SET
SET
SET
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
SET
SET
CREATE TABLE
ALTER TABLE
AL
we should not mix index information while dropping the table
and vice versa.
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
Hi ,
pg_upgrade scenario is failing if database is containing global
temporary table
=
centos@tushar-ldap-docker bin]$ ./psql postgres
psql (13devel)
Type "help" for help.
postgres=# create global temporary table t(n int);
CREATE TABLE
pos
te temp table bar1(n int) on commit delete rows;
CREATE TABLE
i think this error message need to be more clear .
regards,
tushar
On 2/25/20 7:19 PM, Pavel Stehule wrote/:
út 25. 2. 2020 v 14:36 odesílatel Prabhat Sahu
mailto:prabhat.s...@enterprisedb.com>>
napsal:
Hi All,
Pl
this syntax - create global temp
table foo1(n int) *with (on_commit_delete_rows='true'); *
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
1 - 100 of 121 matches
Mail list logo
