Re:Re: What is the best way to upgrade pgAdmin on Windows?

2024-08-15 Thread 毛毛
Hi Ron, The notification I got had a link to the EDB site with a bunch of PostgreSQL installers listed. Thing is, I don't want to mess up my database. What does PgAdmin have to do with your database? I didn't know there was a standalone installer for pgAdmin. This link brought me to this

Re: PostgreSQL Upgrade Issue - Undefined Symbol Error

2024-08-15 Thread Tom Lane
Vivek Gadge writes: > I am encountering an error after completion of PostgreSQL upgradation from > version 13.8 to 15.6. Trying to describe a single table, I am receiving an > error. > psql: symbol lookup error: psql: undefined symbol: PQmblenBounded This indicates that your psql executable is l

Re: PostgreSQL Upgrade Issue - Undefined Symbol Error

2024-08-15 Thread Adrian Klaver
On 8/15/24 04:03, Vivek Gadge wrote: Hi All, I am encountering an error after completion of PostgreSQL upgradation from version 13.8 to 15.6. Trying to describe a single table, I am receiving an error. psql -d xyz -->> \dt student* The error message is as follows: ``` psql: symbol lookup

PostgreSQL Upgrade Issue - Undefined Symbol Error

2024-08-15 Thread Vivek Gadge
Hi All, I am encountering an error after completion of PostgreSQL upgradation from version 13.8 to 15.6. Trying to describe a single table, I am receiving an error. psql -d xyz -->> \dt student* The error message is as follows: ``` psql: symbol lookup error: psql: undefined symbol: PQmblenBoun

Re: Column type modification in big tables

2024-08-15 Thread Lok P
On Fri, Aug 16, 2024 at 2:04 AM Lok P wrote: > > On Thu, Aug 15, 2024 at 9:18 PM Alban Hertroys wrote: > >> >> > On 15 Aug 2024, at 14:15, Lok P wrote: >> >> (…) >> Are all those partitions critical, or only a relative few? >> >> If that’s the case, you could: >> 1) detach the non-criti

Re: Column type modification in big tables

2024-08-15 Thread Lok P
On Thu, Aug 15, 2024 at 9:18 PM Alban Hertroys wrote: > > > On 15 Aug 2024, at 14:15, Lok P wrote: > > (…) > Are all those partitions critical, or only a relative few? > > If that’s the case, you could: > 1) detach the non-critical partitions > 2) take the system down for mainten

Re: Column type modification in big tables

2024-08-15 Thread Alban Hertroys
> On 15 Aug 2024, at 14:15, Lok P wrote: (…) > Hello Greg, > > In terms of testing on sample data and extrapolating, as i picked the avg > partition sizeof the table (which is ~20GB) and i created a non partitioned > table with exactly same columns and populated with similar data and also

Re: What is the best way to upgrade pgAdmin on Windows?

2024-08-15 Thread Adrian Klaver
On 8/14/24 23:34, 毛毛 wrote: Hey there, I just found out my pgAdmin is version 7.6, while the current version is 8.6. Looks like it's time for an upgrade! Per https://www.pgadmin.org/download/pgadmin-4-windows/ The current version is 8.10. The notification I got had a link to the EDB site

Re: What is the best way to upgrade pgAdmin on Windows?

2024-08-15 Thread Ron Johnson
On Thu, Aug 15, 2024 at 2:35 AM 毛毛 wrote: > Hey there, > > I just found out my pgAdmin is version 7.6, while the current version is > 8.6. Looks like it's time for an upgrade! > https://www.pgadmin.org/download/pgadmin-4-windows/ The latest is 8.10. > The notification I got had a link to the

Re: Column type modification in big tables

2024-08-15 Thread Lok P
On Tue, Aug 13, 2024 at 7:39 PM Greg Sabino Mullane wrote: > On Sat, Aug 10, 2024 at 5:06 PM Lok P wrote: > > >> Can someone through some light , in case we get 5-6hrs downtime for this >> change , then what method should we choose for this Alter operation? >> > > We can't really answer that. On