Re: Help with PhD Dissertation

On Tue, Apr 15, 2025 at 05:28:40PM +0200, Karsten Hilbert wrote: > Am Tue, Apr 15, 2025 at 11:26:35AM -0400 schrieb Osmel Brito-Bigott: > > > I'm not collecting emails in the survey > > Don't get me wrong, I am not questioning your good faith or intent. Agreed. The email said: The surv

Re: Help with PhD Dissertation

I'm not collecting emails in the survey El mar, 15 abr 2025 a la(s) 11:25 a.m., Karsten Hilbert ( karsten.hilb...@gmx.net) escribió: > > > > The survey [...] is completely anonymous. > > > > > > Nope. > > > > > > > Can you elaborate on this, please, for my sake and others? > > I was, certainly so

Re: Help with PhD Dissertation

> > > The survey [...] is completely anonymous. > > > > Nope. > > > > Can you elaborate on this, please, for my sake and others? I was, certainly somewhat tersely, trying to point out that using Google Forms nearly precludes anonymity unless one accesses them via Tor or some such. Best regards,

Re: Help with PhD Dissertation

Am Tue, Apr 15, 2025 at 11:26:35AM -0400 schrieb Osmel Brito-Bigott: > I'm not collecting emails in the survey Don't get me wrong, I am not questioning your good faith or intent. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Help with PhD Dissertation

On Tue, Apr 15, 2025 at 7:20 AM Karsten Hilbert wrote: > > The survey [...] is completely anonymous. > > Nope. > Can you elaborate on this, please, for my sake and others?

Re: Help with PhD Dissertation

Am Mon, Apr 14, 2025 at 09:27:30PM -0400 schrieb Osmel Brito-Bigott: > forms.gle > > The survey [...] is completely anonymous. Nope. Karsten Hilbert -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Help with PhD Dissertation

The survey takes only about 5-10 minutes and is completely anonymous. Your participation will help shed light on crucial challenges in OSS development and contribute to academic research on improving the sustainability of open-source communities. Feel free to share this with other OSS developers

Re: Need help understanding has_function_privilege

Hi, and thanks (both of you!) Shouldn't the create role my_user NOINHERIT; avoid this? And since not, why? :-) On Thu, 20 Mar 2025 at 15:07, David G. Johnston wrote: > On Wednesday, March 19, 2025, Cosimo Simeone > wrote: >> >> >> true? >> Well... Ok, "whatever"... I revoke it: >> =# revoke

Re: Need help understanding has_function_privilege

On Friday, March 21, 2025, Cosimo Simeone wrote: > Hi, and thanks (both of you!) > Shouldn't the > create role my_user NOINHERIT; > avoid this? And since not, why? :-) > > We might need to improve documentation surrounding the public pseudo-role a bit. Since it’s not a true group role I suspect

Re: Need help understanding has_function_privilege

On Wednesday, March 19, 2025, Cosimo Simeone wrote: > > > true? > Well... Ok, "whatever"... I revoke it: > =# revoke execute on function my_schema.my_func(text) from my_user; > REVOKE > Roles can inherit privileges. my_user is inheriting its execute privilege from PUBLIC. You have to revoke a g

Re: Need help understanding has_function_privilege

On 3/19/25 04:24, Cosimo Simeone wrote: Hi! I'd need help understanding what i am doing wrong... Where am I: =# \c psql (15.8 (Homebrew), server 14.15 (Debian 14.15-1.pgdg120+1)) You are now connected to database "postgres" as user "postgres". Init: =# create role

Need help understanding has_function_privilege

Hi! I'd need help understanding what i am doing wrong... Where am I: =# \c psql (15.8 (Homebrew), server 14.15 (Debian 14.15-1.pgdg120+1)) You are now connected to database "postgres" as user "postgres". Init: =# create role my_user; =# create schema my_s

Re: Help in vetting outcome of "vacuumdb --analyze-in-stages" - during DB Upgrade from EC2- PGS - Community Edn ver 13.X to 14.X

. 'unknown headache' is not something I can help with. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Help in vetting outcome of "vacuumdb --analyze-in-stages" - during DB Upgrade from EC2- PGS - Community Edn ver 13.X to 14.X

On 2/16/25 08:27, Y_Bharani_mbsv wrote: Adrian TQ for the instant reply. post DB migration to Ver 14.X (successfully) and Post executing the "vacuumdb --analyze-in-stages", i noticed "read me option" and the caveat on it. Did you do: vacuumdb --analyze-in-stages or vacuumdb --all --analyze

Re: Help in vetting outcome of "vacuumdb --analyze-in-stages" - during DB Upgrade from EC2- PGS - Community Edn ver 13.X to 14.X

On 2/16/25 05:13, Y_Bharani_mbsv wrote: Team Good Morning. As part of DB upgrade from EC2 - PGS - community Edn Ver 13.X to 14.X I followed steps of "pg_upgrade" and had executed the last step (post successful db migration) vacuumdb --analyze-in-stages and later noticed an caveat url = https:

Re: Help in vetting outcome of "vacuumdb --analyze-in-stages" - during DB Upgrade from EC2- PGS - Community Edn ver 13.X to 14.X

On Sun, Feb 16, 2025 at 8:13 AM Y_Bharani_mbsv wrote: > Team > Good Morning. > As part of DB upgrade from EC2 - PGS - community Edn Ver 13.X to 14.X > I followed steps of "pg_upgrade" and had executed the last step (post > successful db migration) > > vacuumdb --analyze-in-stages > > and later no

Re: Help in vetting Switch from "MD5" to "scram-sha-256" - during DB Upgrade from EC2- PGS - Community Edn ver 13.X to 15.X

On 2/6/25 18:03, Bharani SV-forum wrote: Adrian TQ for your valuable input's. *Additional Qsn* Assume  DB ver = 15.X By default encryption = scram-sha-256, Assume pg_hba.conf is quoted the usage as MD5 for the  dbuserid "test_usr_1" *e.g .)* * * hostssl   all test_usr_1 10.20.30.40  md5 i

Re: Help in vetting Switch from "MD5" to "scram-sha-256" - during DB Upgrade from EC2- PGS - Community Edn ver 13.X to 15.X

On 2/6/25 16:37, Bharani SV-forum wrote:  Team I am in the process of doing DB Upgrade from EC2- PGS - Community Edn ver 13.X to 15.X including switching from "MD5 " to "scram-sha-256" for password hashing and authentication. We are having tightly integrated appln tech stack having 256+ role

Re: Help in vetting measuring egress/ingress w.r.to " pg_dumpall " - old vm to new vm

On 1/28/25 12:13, Bharani SV-forum wrote: TQ Adrian another Question on the measuring egress (out bound traffic) /ingress (inbound traffic) w.r.to " pg_dumpall " during usage of Since you are using AWS EC2(?) instances wouldn't the AWS dashboard show you this? pg_dumpall -h    -p 5432 | p

Re: Help in vetting measuring egress/ingress w.r.to " pg_dumpall " - old vm to new vm

On Tue, Jan 28, 2025 at 3:13 PM Bharani SV-forum wrote: > TQ Adrian > another Question on the measuring egress (out bound traffic) /ingress > (inbound traffic) w.r.to " pg_dumpall " during usage of > > pg_dumpall -h-p 5432 | psql -p 5462 > > taking data from old_vm and copying to new_vm, as i

Help in vetting measuring egress/ingress w.r.to " pg_dumpall " - old vm to new vm

TQ Adriananother Question on the measuring egress (out bound traffic) /ingress (inbound traffic) w.r.to " pg_dumpall " during usage of  pg_dumpall-h    -p 5432 | psql -p 5462 taking data from old_vm and copying to new_vm, as i need to use across the network for taking data and i cannot use "pg_

Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 14.X/15.X and issue with python binaries

On 1/28/25 08:23, Bharani SV-forum wrote: Team Need your help. We are trying to use existing VM with underlying OS = Amazon Linux 2 (AL2)  along with Pgsql ver 13.X community edn. Trying to upgrade from 13.X to 15.X and had hit the bottleneck for the mandate to have python ver 3.X binaries. We

Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 14.X/15.X and issue with python binaries

TeamNeed your help.We are trying to use existing VM with underlying OS = Amazon Linux 2 (AL2)  along with Pgsql ver 13.X community edn.Trying to upgrade from 13.X to 15.X and had hit the bottleneck for the mandate to have python ver 3.X binaries.We have limitation with the existing VM with AWS

Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 1/24/25 10:01 AM, Bharani SV-forum wrote: Adrian Thanks This is the exact error which the system admin is facing  postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency Which from your post the admin said was due to: "His version is "It needs li

Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

AdrianThanks This is the exact error which the system admin is facing  postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency "https://www.postgresql.org/message-id/CABUevEz_OHR%2BaGU%2B7yuhpfJD%2BeWgC8aHgVRjP5U30kJqu%2B7jmg%40mail.gmail.com"; On Friday, J

Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 1/24/25 07:50, Bharani SV-forum wrote: Team Need your additional input. VM is based on EC2 OS Version = Amazon Linux 2 Existing DB version = 13.X - Pg Community under EC2 - VM (Same VM) Target DB version = 15.x  - Pg Community under EC2 - VM (Same VM) i will narrate the latest error execut

Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

TeamNeed your additional input.VM is based on EC2 OS Version = Amazon Linux 2  Existing DB version = 13.X - Pg Community under EC2 - VM (Same VM)Target DB version = 15.x  - Pg Community under EC2 - VM (Same VM) i will narrate the latest error executing: SELECT pg_catalog.set_config('search_path

Re: Need help in logical replication

roup. I’ve created a publication on the primary and a subscription >> on the secondary, and the replication slot has been created. However, the >> slot remains inactive, and changes aren’t being applied on the subscriber. >> >> I am using AWS RDS for that >> >> Cou

Re: Need help in logical replication

ges aren’t being applied on the subscriber. > > I am using AWS RDS for that > > Could you please help me identify the possible cause and resolution for > this issue? > > Thank you in advance! > > [image: image.png] > [image: image.png] > > CREATE PUBLICATION

Re: Need help in logical replication

ondary, and the replication slot has been created. However, the slot > remains inactive, and changes aren’t being applied on the subscriber. > > I am using AWS RDS for that > > Could you please help me identify the possible cause and resolution for this > issue? > > Tha

Need help in logical replication

applied on the subscriber. I am using AWS RDS for that Could you please help me identify the possible cause and resolution for this issue? Thank you in advance! [image: image.png] [image: image.png] CREATE PUBLICATION logical_replication_test FOR TABLE dbo.logical_rep_test; CREATE SUBSCRIPTION

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

Team I followed Greg suggested steps .One of big had only one table and around four million recordsi am doing dev env restoration into new vmthe target VM env is an POC server and took 3 hrs to restore four million records.Now it is doing process of lo_open / lo_close /  lowrite  etci.e  pg-dum

Re: Need help in database design

You might also look into using a bitmap, for some or all of those fields. It depends on how many distinct values each can have, of course, and also on how exactly they are accessed, but bitmaps can save you quite a bit of space. Cheers, Greg

Re: Need help in database design

On Mon, Dec 23, 2024 at 11:26 AM Divyansh Gupta JNsThMAudy < ag1567...@gmail.com> wrote: > > gdid int8 GENERATED BY DEFAULT AS IDENTITY( INCREMENT BY 1 MINVALUE 1 > MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE) NOT NULL, > > userid int8 NOT NULL, > > useremail varchar(600) NOT NULL, > > t

Re: Need help in database design

Just out of curiosity, not suggestion this is the solution. Why save json in PostgreSQL and not in a DB specialised on JSON like MongoDB? Divyansh Gupta JNsThMAudy escribió: Thank you everyone for giving your valuable responses, I am glad that everyone understands my concern. I got some go

Re: Need help in database design

The current application does not have support for that, If I go for that, it will require a lot of effort from the team which Is not possible right now. On Tue, 24 Dec 2024, 12:47 am , wrote: > Just out of curiosity, not suggestion this is the solution. Why save json > in PostgreSQL and not in a

Re: Need help in database design

ec 23, 2024 at 1:32 PM Divyansh Gupta JNsThMAudy < > ag1567...@gmail.com> wrote: > >> Currently I haven't created those columns , I have created addons_json >> column which is a JSONB column yet in a discussion weather I should create >> or consider only one JSONB c

Re: Need help in database design

et in a discussion weather I should create > or consider only one JSONB column. > > On Tue, 24 Dec 2024, 12:00 am Divyansh Gupta JNsThMAudy, < > ag1567...@gmail.com> wrote: > >> Range partition can help when you applies filter for a specific range but >> in my case I ne

Re: Need help in database design

ch is a JSONB column yet in a discussion weather I should create or > consider only one JSONB column. > > > On Tue, 24 Dec 2024, 12:00 am Divyansh Gupta JNsThMAudy, <mailto:ag1567...@gmail.com>> wrote: >> Range partition can help when you applies filter for a specific

Re: Need help in database design

Currently I haven't created those columns , I have created addons_json column which is a JSONB column yet in a discussion weather I should create or consider only one JSONB column. On Tue, 24 Dec 2024, 12:00 am Divyansh Gupta JNsThMAudy, < ag1567...@gmail.com> wrote: > Range part

Re: Need help in database design

Range partition can help when you applies filter for a specific range but in my case I need to apply filter on userid always, however I have date columns but there is less variation in timestamp which I have that's why didn't go for range partition. On Mon, 23 Dec 2024, 11:57 pm R

Re: Need help in database design

Where are the 50 "t* columns? On Mon, Dec 23, 2024 at 1:26 PM Divyansh Gupta JNsThMAudy < ag1567...@gmail.com> wrote: > Ron here is the entire table schema FYI, userid is the mandate column on > which filter is always applies: > > CREATE TABLE dbo.googledocs_tbl ( > > gdid int8 GENERATED BY DEFAU

Re: Need help in database design

1. I bet you'd get better performance using RANGE partitioning. 2. Twenty million rows per userid is a *LOT*. No subdivisions (like date range)? On Mon, Dec 23, 2024 at 1:23 PM Divyansh Gupta JNsThMAudy < ag1567...@gmail.com> wrote: > Adrian, Please check this out; > > PARTITION BY HASH (userid)

Re: Need help in database design

Ron here is the entire table schema FYI, userid is the mandate column on which filter is always applies: CREATE TABLE dbo.googledocs_tbl ( gdid int8 GENERATED BY DEFAULT AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE) NOT NULL, userid int8 NOT NULL,

Re: Need help in database design

Adrian, Please check this out; PARTITION BY HASH (userid); CREATE TABLE dbo.googledocs_tbl_clone_part_0 PARTITION OF dbo.googledocs_tbl_clone FOR VALUES WITH (modulus 84, remainder 0); ... CREATE TABLE dbo.googledocs_tbl_clone_part_83 PARTITION OF dbo. googledocs_tbl_clone FOR VALUES WITH (modulus

Re: Need help in database design

Adrian, the partition is on userid using hash partition with 84 partitions Ron, there could be more than 20 Million records possible for a single userid in that case if I create index on userid only not on other column the query is taking more than 30 seconds to return the results. On Mon, 23 Dec

Re: Need help in database design

If your queries all reference userid, then you only need indices on gdid and userid. On Mon, Dec 23, 2024 at 12:49 PM Divyansh Gupta JNsThMAudy < ag1567...@gmail.com> wrote: > I have one confusion with this design if I opt to create 50 columns I need > to create 50 index which will work with user

Re: Need help in database design

On 12/23/24 09:49, Divyansh Gupta JNsThMAudy wrote: I have one confusion with this design if I opt to create 50 columns I need to create 50 index which will work with userid index in Bitmap on the other hand if I create a JSONB column I need to create a single index ? There still is the part

Re: Need help in database design

I have one confusion with this design if I opt to create 50 columns I need to create 50 index which will work with userid index in Bitmap on the other hand if I create a JSONB column I need to create a single index ? On Mon, 23 Dec 2024, 11:10 pm Ron Johnson, wrote: > Given what you just wrote,

Re: Need help in database design

Given what you just wrote, I'd stick with 50 separate t* columns. Simplifies queries, simplifies updates, and eliminates JSONB conversions. On Mon, Dec 23, 2024 at 12:29 PM Divyansh Gupta JNsThMAudy < ag1567...@gmail.com> wrote: > Values can be updated based on customer actions > > All rows won't

Re: Need help in database design

Empty JSONB by mistake, I wrote array sorry about that On Mon, 23 Dec 2024, 10:59 pm Divyansh Gupta JNsThMAudy, < ag1567...@gmail.com> wrote: > Values can be updated based on customer actions > > All rows won't have all 50 key value pairs always if I make those keys > into columns the rows might

Re: Need help in database design

Values can be updated based on customer actions All rows won't have all 50 key value pairs always if I make those keys into columns the rows might have null value on the other hand if it is JSONB then the key value pair will not be there Yes in UI customers can search for the key value pairs Dur

Re: Need help in database design

Let's make it more understandable, here is the table schema with 50 columns in it CREATE TABLE dbo.googledocs_tbl ( gdid int8 GENERATED BY DEFAULT AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE) NOT NULL, userid int8 NOT NULL, t1 int4 NULL, t2 int4 NUL

Re: Need help in database design

;>> > > weather I create 50 new columns of int2 data type each >>>> column >>>> > will >>>> > >>>> > This is unclear, I am trying to figure out you go from '50 key >>>> >

Re: Need help in database design

On 12/23/24 09:07, Divyansh Gupta JNsThMAudy wrote: Each row have a PK (gdid) that will uniquely refrence 50 k/v pair set Are the 50 key/value pairs there to just define a PK or are they going to be used in some other combination in queries? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Need help in database design

On Mon, Dec 23, 2024, 10:01 Divyansh Gupta JNsThMAudy wrote: > > So here my question is considering one JSONB column is perfect or > considering 50 columns will be more optimised. > The relational database engine is designed around the column-based approach. Especially if the columns are general

Re: Need help in database design

; >>> > This is unclear, I am trying to figure out you go from '50 key >>> > value >>> > pair set' to '50 new columns of int2'. >>> > >>> > In other words how 50 pairs turn into 50 columns

Re: Need help in database design

On 12/23/24 09:01, Divyansh Gupta JNsThMAudy wrote: Sure , for example, I have 50 key with name as t1 , t2 ,t3 ...t50 Now each key could have values from 0 to 3 So let suppose we have JSONB like that for row r1 { t1: 1 t2: 2 t3 : 3 } As if I convert it into columns so r1 will have t

Re: Need help in database design

int2'. >> > >> > In other words how 50 pairs turn into 50 columns? >> > >> > Then there is the question of why 50 keys per row in the first >> > place? >> > >> > >> > > contain value

Re: Need help in database design

> > place? > > > > > > > contain value of a specific key or should I go with JSONB > > data type with > > > 50 key value pair, the table on which I am going to do that > > all contains > > &

Re: Need help in database design

On 12/23/24 08:55, David G. Johnston wrote: On Mon, Dec 23, 2024, 09:54 Adrian Klaver > wrote: On 12/23/24 08:46, Divyansh Gupta JNsThMAudy wrote: > Also as you ask how 50 pairs turns into 50 column so each column will be > a key and the value

Re: Need help in database design

On Mon, Dec 23, 2024, 09:54 Adrian Klaver wrote: > On 12/23/24 08:46, Divyansh Gupta JNsThMAudy wrote: > > Also as you ask how 50 pairs turns into 50 column so each column will be > > a key and the value of that key will store inside their respective > > column for each row > > My problem with un

Re: Need help in database design

ave gone through > multiple articles some of them mentioned it's a good approach to create > 50 new columns and some states that creating one JSONB would be best > that's why I need your help to move forward, also I am ready

Re: Need help in database design

or should I go with JSONB data type >> with >> > 50 key value pair, the table on which I am going to do that all >> contains >> > 1 Billion rows of data and have 84 hash partitions, I have gone through >> > multiple articles some of them mentioned it's a go

Re: Need help in database design

the table on which I am going to do that all contains > > 1 Billion rows of data and have 84 hash partitions, I have gone through > > multiple articles some of them mentioned it's a good approach to create > > 50 new columns and some states that creating one JSONB would be best &

Re: Need help in database design

e best that's why I need your help to move forward, also I am ready to make H-Store instead of JSONB if it provides better performance. Please help me to comes out from that dilemma. Regards, Divyansh Gupta, Database Administrator -- Adrian Klaver adrian.kla...@aklaver.com

Need help in database design

27;s why I need your help to move forward, also I am ready to make H-Store instead of JSONB if it provides better performance. Please help me to comes out from that dilemma. Regards, Divyansh Gupta, Database Administrator

Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

TeamBeing dev server, I noticed, we haven't performed analyze/vacuum process. Noticed and re-triggerred vacuum full and analyze for all the application related db's Re ran backup. No issue's appeared during backup. Not yet performed restoration in pgsql ver 15.09 in new vm with different OS. Than

Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/16/24 14:30, Bharani SV-forum wrote: *a) * *user = * postgres b) *pg_dump version = * /usr/bin/pg_dump -V pg_dump (PostgreSQL) 13.16 c) *DB version* select version () ;                                                  version ---

Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

a) user = postgres b)pg_dump version = /usr/bin/pg_dump -V pg_dump (PostgreSQL) 13.16 c) DB version select version () ;                                                  version--  PostgreSQL 13.

Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/16/24 13:19, Bharani SV-forum wrote: Team I am getting the following error. pg_dump: error: error reading large object 2113418: pg_dump: error: could not open large object 3391830: What user are you running pg_dump as? What version of pg_dump? I tried to give this command DB name =

Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

TeamI am getting the following error. pg_dump: error: error reading large object 2113418: pg_dump: error: could not open large object 3391830:  I tried to give this command DB name = abcefg ALTER DATABASE abcefgd SET lo_compat_privileges=on; and reran and once again , i am getting the same error

Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/11/24 11:12, Bharani SV-forum wrote: Team As suggested from old server, post shutdown of DB, I did OS level dump of PG_DATA folder and had restored in the new server. If you follow the process shown here: https://www.postgresql.org/message-id/CAKAnmmKZdhnhdNRd3OgDyEco9OPkT%3DqA_TeWMFMRv

Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

TeamAs suggested from old server, post shutdown of DB, I did OS level dump of PG_DATA folder and had restored in the new server. Any idea on how to install the older binary postgres 13.18 ( OS=Amazon Linux 2023.6.20241121) under a dedicated folder suffixed as the following e.g.) /usr/pgsql1318

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/4/24 04:42, Bharani SV-forum wrote: Team /Ron/Adrian Wann to reconfirm we have an setup with new server will be with will be following the following suggestion *On old VM* [ existing server with OS "Amazon Linux release 2 (Karoo) " present in aws "us-east-1 region" and along with postg

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On Wed, Dec 4, 2024 at 7:42 AM Bharani SV-forum wrote: > a) is the above said steps is correct with the given existing and proposed > setup > No. Here are some steps: * Install Postgres on the new VM However you get it, use the newest version you can. As of this writing, it is Postgres 17.2. Ve

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On Wed, Dec 4, 2024 at 7:42 AM Bharani SV-forum wrote: > Team /Ron/Adrian > > Wann to reconfirm > we have an setup with > > new server will be with > > will be following the following suggestion > > *On old VM* [ existing server with OS "Amazon Linux release 2 (Karoo) " > present in aws "us-east-

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

Team /Ron/Adrian Wann to reconfirmwe have an setup with  new server will be with  will be following the following suggestion On old VM [ existing server with OS "Amazon Linux release 2 (Karoo) " present in aws "us-east-1 region" and along with postgresql ver 13.16.2  - community edn ]  - "take

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/2/24 17:23, Ron Johnson wrote: Adrian, OP is moving to a new VM when migrating to PG 15.  When was the "cross-server" feature added to pg_upgrade? Moving to a new VM was not the issue, my mistake was thinking the OS version was staying the same. Then: On old VM: "take offline ful

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

c 2, 2024 at 5:18 PM Bharani SV-forum > >> mailto:esteembsv-fo...@yahoo.com>> wrote: > >> > >> Team > >> Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to > >> ver 15.X > >> > >> Env = EC2 based C

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 2024-12-03 00:25:15 +, Bharani SV-forum wrote: > qsn1: What is the size of database(s) you are dealing with? > ans1: roughly 25 GB (maximum size) > > qsn2 : What sort of downtime can you afford? > ans2: can be maximum 30 mins or so That does seem sufficient time to dump/restore a 25 GB da

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

AdrianNoted about, Logical replication would not have issue with this as that is one of it's use cases. qsn1: What is the size of database(s) you are dealing with? ans1: roughly 25 GB  (maximum size) qsn2 : What sort of downtime can you afford? ans2: can be maximum 30 mins or so qsn3: EC2 --> E

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/2/24 15:52, Bharani SV-forum wrote: Adrian Proposed new Server is intended to have higher OS Version (centos ver 9.0) and higher Postgres Version 15.10 Alright I did not catch this " ... with new OS" from your original post. I saw "Take offline full backup (PG_DATA folder alone) using

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

46, Adrian Klaver wrote: >  > On 12/2/24 14:31, Ron Johnson wrote: >  >> On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum >  >> mailto:esteembsv-fo...@yahoo.com> > <mailto:esteembsv-fo...@yahoo.com>> wrote: >  >> >  >>     Team >  >>     Pl Help in v

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

; On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum >> mailto:esteembsv-fo...@yahoo.com> <mailto:esteembsv-fo...@yahoo.com>> wrote: >> >>     Team >>     Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to >>     ver 15.X >> >

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

to:esteembsv-fo...@yahoo.com>> wrote: >> >>     Team >>     Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to >>     ver 15.X >> >>     Env = EC2 based Community PostgreSQL Ver 13.16.2 >> >>     we will be performing upgrad

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/2/24 14:46, Adrian Klaver wrote: On 12/2/24 14:31, Ron Johnson wrote: On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum mailto:esteembsv-fo...@yahoo.com>> wrote:     Team     Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to     ver 15.X     Env = EC2 based Com

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/2/24 14:31, Ron Johnson wrote: On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum mailto:esteembsv-fo...@yahoo.com>> wrote: Team Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Env = EC2 based Community PostgreSQL Ver 13.16.2 we w

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum wrote: > Team > Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver > 15.X > > Env = EC2 based Community PostgreSQL Ver 13.16.2 > > we will be performing upgrade of our EC2 server too along with new OS. >

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/2/24 14:18, Bharani SV-forum wrote: Team Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Env = EC2 based Community PostgreSQL Ver 13.16.2 we will be performing upgrade of our EC2 server too along with new OS. Need help in vetting my steps for Postgres DB

Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

TeamPl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Env = EC2 based Community PostgreSQL Ver 13.16.2 we will be performing upgrade of our EC2 server too along with new OS. Need help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X  ASIS

Help with syntax error

I have these tables: *CREATE TABLE IF NOT EXISTS registrar ( index SERIAL, registrar_id TEXT, day TEXT NOT NULL, month TEXT NOT NULL, year TEXT NOT NULL, hour TEXT NOT NULL, minute TEXT NOT NULL, second TEXT NOT NULL, millisecond TEXT NOT NULL, am_pm TEXT NOT NULL, admin BOOLEAN NOT NULL DEFAULT

Re: Help with syntax error

On Sun, Dec 1, 2024 at 7:14 PM Arbol One wrote: > I have these tables: > > > > > > > > > > > > > > > > > > > > *CREATE TABLE IF NOT EXISTS registrar ( index SERIAL, registrar_id TEXT, > day TEXT NOT NULL, month TEXT NOT NULL, year TEXT NOT NULL, hour TEXT NOT > NULL, minute TEXT NOT NULL, second

Re: Help with syntax error

😳 O, I feel so dumb, that I find it so funny!! Thanks man!!! I need to step away from the computer for a while, I think fatigue is getting the best of me. On 2024-12-01 7:17 p.m., Adrian Klaver wrote: On 12/1/24 16:14, Arbol One wrote: I have these tables: *CREATE TABLE IF NOT EXISTS re

Re: Help with syntax error

On 12/1/24 16:14, Arbol One wrote: I have these tables: *CREATE TABLE IF NOT EXISTS registrar ( index SERIAL, registrar_id TEXT, day TEXT NOT NULL, month TEXT NOT NULL, year TEXT NOT NULL, hour TEXT NOT NULL, minute TEXT NOT NULL, second TEXT NOT NULL, millisecond TEXT NOT NULL, am_pm TEXT NOT N

Re: Help with restoring database from old version of PostgreSQL

On 2024-11-19 16:47:40 -0500, Catherine Frock wrote: > I am trying to restore a previously backed up database .sql file that was > created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was > using). > > In response to Ron: Do I need to use PG16 instead of pgAdmin4? As Ron already

Re: Help with restoring database from old version of PostgreSQL

Adrian: Yes, db_2017 is the name I originally gave the database in the PostgreSQL 9.6 server. I can't remember if I used pg_dump or pg_dumpall. Ron: Okay, I think it finally worked! Thank you both for your help. -- Arden On Tue, Nov 19, 2024 at 6:00 PM Adrian Klaver wrote: > On 11/

Re: Help with restoring database from old version of PostgreSQL

Ah, so it's a plain old SQL file. That makes things much easier!! Here's the thing: PG (whether 9.6 or 16 or 17) is the database engine; no GUI, and just a basic command line interface. PgAdmin4 is a GUI interface to PG. Newer versions of PgAdmin4 are not compatible with EOL PG versions like 9.6

Re: Help with restoring database from old version of PostgreSQL

On 11/19/24 14:13, Catherine Frock wrote: Do you know what versions of PG and pgAdmin4 I need? Also, I don't know where to get a different version of PG. You need to take a step back and take stock of where you started and where you want to be. To that end answer the following: 1) What ar

Re: Help with restoring database from old version of PostgreSQL

Do you know what versions of PG and pgAdmin4 I need? Also, I don't know where to get a different version of PG. -- Arden On Tue, Nov 19, 2024 at 5:01 PM Ron Johnson wrote: > Ah, so it's a plain old SQL file. That makes things much easier!! > > Here's the thing: PG (whether 9.6 or 16 or 17) is

  1   2   3   4   5   6   7   >