seadba
commented
1 year ago looks like a build might work - but can we confirm that zypper is not the correct utility? thanks
/depot/pgloader/build/bin # ./pgloader --version
pgloader version "3.6.999791d"
compiled with SBCL 2.1.0-bp153.1.63-suse
Hello, we are planning a migration from mysql to postgresql on suse 15.4 - we have tested pgloader successfully on other platforms - i appologize if i missed something on this install but it does not seem complete
zypper search pgloader
S | Name | Summary | Type ---+----------+---------------------------------+-------- i+ | pgloader | Fast data loader for PostgreSQL | package
# zypper install pgloader The following NEW package is going to be installed: pgloader 1 new package to install. Overall download size: 150.9 KiB. Already cached: 0 B. After the operation, additional 357.7 KiB will be used. Continue? [y/n/v/...? shows all options] (y): y Retrieving package pgloader-3.6.2-bp153.1.25.x86_64 (1/1), 150.9 KiB (357.7 KiB unpacked) Retrieving: pgloader-3.6.2-bp153.1.25.x86_64.rpm ...........[done (362.0 KiB/s)] Checking for file conflicts: .............................................[done] (1/1) Installing: pgloader-3.6.2-bp153.1.25.x86_64 .......................[done]
zypper info pgloader
Loading repository data... Reading installed packages... Information for package pgloader:
Repository : Main Repository Name : pgloader Version : 3.6.2-bp153.1.25 Arch : x86_64 Vendor : openSUSE Installed Size : 357.7 KiB Installed : Yes Status : up-to-date Source package : pgloader-3.6.2-bp153.1.25.src Upstream URL : https://pgloader.io Summary : Fast data loader for PostgreSQL Description : pgloader imports data from different kind of sources and COPY it into PostgreSQL. The command language is described in the manual page and allows to describe where to find the data source, its format, and to describe data processing and transformation. Supported source formats include SQL Server, CSV, fixed width flat files, dBase3 files (DBF), and SQLite and MySQL databases. In most of those formats, pgloader is able to auto-discover the schema and create the tables and the indexes in PostgreSQL. In the MySQL case it's possible to edit CASTing rules from the pgloader command directly.
/usr/bin> pgloader --version SBCL 2.1.0-bp153.1.63-suse
/usr/bin> pgloader --version SBCL 2.1.0-bp153.1.63-suse
does it require to be built on suse rather than a package? thanks