PostgreSQL 11 packages gone from reporpms?

[PGUser2020]

Hello

PostgreSQL 11 appears to be missing from 

https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

As of maybe the 2nd / 3rd Jan

There is nothing in the "Archived Repositories" for 11, the latest there is 10.

We have a project underway to move to 15, but for now we still need to build 
against 11

Where should I get the PostgreSQL 11 yum packages from in the mean time please?

Thanks

Re: PostgreSQL 11 packages gone from reporpms?

[PGUser2020]

To answer my own question, 11 just now appeared in the archives. So we're 
happily building once more.

Looks like I might have fallen somewhere in between it being taken out of the 
main repo and added to archive.

On 2024-01-04 08:42 +00:00 GMT, "PGUser2020"  wrote:
> Hello
> 
> PostgreSQL 11 appears to be missing from 
> 
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> 
> As of maybe the 2nd / 3rd Jan
> 
> There is nothing in the "Archived Repositories" for 11, the latest there is 
> 10.
> 
> We have a project underway to move to 15, but for now we still need to build 
> against 11
> 
> Where should I get the PostgreSQL 11 yum packages from in the mean time 
> please?
> 
> Thanks
> 
> 

Re: PostgreSQL 11 packages gone from reporpms?

[Devrim Gündüz]

Hi,

On Thu, 2024-01-04 at 08:42 +, PGUser2020 wrote:
> PostgreSQL 11 appears to be missing from 
> 
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> 
> As of maybe the 2nd / 3rd Jan
> 
> There is nothing in the "Archived Repositories" for 11, the latest
> there is 10.
> 
> We have a project underway to move to 15, but for now we still need to
> build against 11
> 
> Where should I get the PostgreSQL 11 yum packages from in the mean
> time please?

I pushed them to archive repos today. Updated archive repo info in here
as well:

https://yum.postgresql.org/repopackages/#pgredhatoldrepos

Regards,
-- 
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: PostgreSQL 11 packages gone from reporpms?

[PGUser2020]

Yep, got them, many thanks.

On 2024-01-04 14:45 +00:00 GMT, "Devrim Gündüz"  wrote:
 
> I pushed them to archive repos today. Updated archive repo info in here
> as well:
> 
> https://yum.postgresql.org/repopackages/#pgredhatoldrepos
> 
> Regards,
> -- 
> Devrim Gündüz
> Open Source Solution Architect, PostgreSQL Major Contributor
> Twitter: @DevrimGunduz , @DevrimGunduzTR
> 

Re: Import csv to temp table

[Paolo Saudin]

Il giorno mar 2 gen 2024 alle ore 21:17 Adrian Klaver <
adrian.kla...@aklaver.com> ha scritto:

> On 1/2/24 11:47, arun chirappurath wrote:
>
> Reply to list
> Ccing list
> > Hi Adrian,
> >
> > Love this tool..however it doesn't like supporting RDS.
>
> 1) This was Daniel Vérité's suggestion not mine.
>
> 2) Define "... doesn't like supporting RDS".
>
> a) You can generate an SQL statement without connecting to the database.
> Then use that statement directly in the database.
>
> b) If SQLAlchemy can reach the database then csvkit should be able to.
>
> >
> > https://csvkit.readthedocs.io/en/latest/
> > 
> >
> > Regards
> > Arun
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>
>
>
You can user pgloader (https://pgloader.io/) as well to load data from CSV
to Postgres
Paolo

Re: Import csv to temp table

[Ryan Kelly]

I use csv2table almost every day: https://github.com/f0rk/csv2table

to just emit a create table statement: csv2table --file your_csv.csv

pipe output to psql to create.

easily used to import data as: csv2table --file your_csv.csv --copy
--backslash -1 | psql your_database

use arguments like --timestamp to automagically detect types.

On Fri, Jan 5, 2024 at 12:45 AM Paolo Saudin  wrote:

> Il giorno mar 2 gen 2024 alle ore 21:17 Adrian Klaver <
> adrian.kla...@aklaver.com> ha scritto:
>
>> On 1/2/24 11:47, arun chirappurath wrote:
>>
>> Reply to list
>> Ccing list
>> > Hi Adrian,
>> >
>> > Love this tool..however it doesn't like supporting RDS.
>>
>> 1) This was Daniel Vérité's suggestion not mine.
>>
>> 2) Define "... doesn't like supporting RDS".
>>
>> a) You can generate an SQL statement without connecting to the database.
>> Then use that statement directly in the database.
>>
>> b) If SQLAlchemy can reach the database then csvkit should be able to.
>>
>> >
>> > https://csvkit.readthedocs.io/en/latest/
>> > 
>> >
>> > Regards
>> > Arun
>> >
>>
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com
>>
>>
>>
> You can user pgloader (https://pgloader.io/) as well to load data from
> CSV to Postgres
> Paolo
>