While building my PostgreSQL environment for the class, I had to write a couple utilities. They do the following:
- Drops all the tables from a schema.
- Drops all the sequences from a schema that aren’t tied to an
_id column with a SERIAL data type.
- Drops all the functions and procedures (qualified as routines) from a schema.
- Drops all the triggers from a schema.
The following gives you the code for all four files: drop_tables.sql, drop_sequences.sql, drop_routines.sql, and drop_triggers.sql.
- The drop_tables.sql Script:
/* Verify all tables present. */
SELECT table_name
FROM information_schema.tables
WHERE table_catalog = current_setting('videodb.catalog_name')
AND table_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
table_cursor CURSOR FOR
SELECT table_name
FROM information_schema.tables
WHERE table_catalog = current_setting('videodb.catalog_name')
AND table_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN table_cursor;
LOOP
/* Fetch table names. */
FETCH table_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP TABLE IF EXISTS '||row.table_name||' CASCADE';
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE table_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT table_name
FROM information_schema.tables
WHERE table_catalog = current_setting('videodb.catalog_name')
AND table_schema = 'public'; |
/* Verify all tables present. */
SELECT table_name
FROM information_schema.tables
WHERE table_catalog = current_setting('videodb.catalog_name')
AND table_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
table_cursor CURSOR FOR
SELECT table_name
FROM information_schema.tables
WHERE table_catalog = current_setting('videodb.catalog_name')
AND table_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN table_cursor;
LOOP
/* Fetch table names. */
FETCH table_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP TABLE IF EXISTS '||row.table_name||' CASCADE';
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE table_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT table_name
FROM information_schema.tables
WHERE table_catalog = current_setting('videodb.catalog_name')
AND table_schema = 'public';
- The drop_sequences.sql script:
/* Verify all tables present. */
SELECT sequence_name
FROM information_schema.sequences
WHERE sequence_catalog = current_setting('videodb.catalog_name')
AND sequence_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
sequence_cursor CURSOR FOR
SELECT sequence_name
FROM information_schema.sequences
WHERE sequence_catalog = current_setting('videodb.catalog_name')
AND sequence_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN sequence_cursor;
LOOP
/* Fetch table names. */
FETCH sequence_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP SEQUENCE IF EXISTS '||row.sequence_name;
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE sequence_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT sequence_name
FROM information_schema.sequences
WHERE sequence_catalog = current_setting('videodb.catalog_name')
AND sequence_schema = 'public'; |
/* Verify all tables present. */
SELECT sequence_name
FROM information_schema.sequences
WHERE sequence_catalog = current_setting('videodb.catalog_name')
AND sequence_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
sequence_cursor CURSOR FOR
SELECT sequence_name
FROM information_schema.sequences
WHERE sequence_catalog = current_setting('videodb.catalog_name')
AND sequence_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN sequence_cursor;
LOOP
/* Fetch table names. */
FETCH sequence_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP SEQUENCE IF EXISTS '||row.sequence_name;
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE sequence_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT sequence_name
FROM information_schema.sequences
WHERE sequence_catalog = current_setting('videodb.catalog_name')
AND sequence_schema = 'public';
- The drop_routines.sql script:
/* Verify all tables present. */
SELECT routine_name
, routine_type
FROM information_schema.routines
WHERE specific_catalog = current_setting('videodb.catalog_name')
AND specific_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
routine_cursor CURSOR FOR
SELECT routine_name
, routine_type
FROM information_schema.routines
WHERE specific_catalog = current_setting('videodb.catalog_name')
AND routine_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN routine_cursor;
LOOP
/* Fetch table names. */
FETCH routine_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP '||row.routine_type||' IF EXISTS '||row.routine_name;
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE routine_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT routine_name
, routine_type
FROM information_schema.routines
WHERE specific_catalog = 'videodb'
AND specific_schema = 'public'; |
/* Verify all tables present. */
SELECT routine_name
, routine_type
FROM information_schema.routines
WHERE specific_catalog = current_setting('videodb.catalog_name')
AND specific_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
routine_cursor CURSOR FOR
SELECT routine_name
, routine_type
FROM information_schema.routines
WHERE specific_catalog = current_setting('videodb.catalog_name')
AND routine_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN routine_cursor;
LOOP
/* Fetch table names. */
FETCH routine_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP '||row.routine_type||' IF EXISTS '||row.routine_name;
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE routine_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT routine_name
, routine_type
FROM information_schema.routines
WHERE specific_catalog = 'videodb'
AND specific_schema = 'public';
- The drop_triggers.sql script:
/* Verify all tables present. */
SELECT trigger_name
FROM information_schema.triggers
WHERE trigger_catalog = current_setting('videodb.catalog_name')
AND trigger_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
trigger_cursor CURSOR FOR
SELECT trigger_name
FROM information_schema.triggers
WHERE trigger_catalog = current_setting('videodb.catalog_name')
AND trigger_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN trigger_cursor;
LOOP
/* Fetch table names. */
FETCH trigger_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP TRIGGER IF EXISTS '||row.trigger_name;
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE trigger_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT trigger_name
FROM information_schema.triggers
WHERE trigger_catalog = current_setting('videodb.catalog_name')
AND trigger_schema = 'public'; |
/* Verify all tables present. */
SELECT trigger_name
FROM information_schema.triggers
WHERE trigger_catalog = current_setting('videodb.catalog_name')
AND trigger_schema = 'public';
DO $$
DECLARE
/* Declare an indefinite length string and record variable. */
sql VARCHAR;
row RECORD;
/* Declare a cursor. */
trigger_cursor CURSOR FOR
SELECT trigger_name
FROM information_schema.triggers
WHERE trigger_catalog = current_setting('videodb.catalog_name')
AND trigger_schema = 'public';
BEGIN
/* Open the cursor. */
OPEN trigger_cursor;
LOOP
/* Fetch table names. */
FETCH trigger_cursor INTO row;
/* Exit when no more records are found. */
EXIT WHEN NOT FOUND;
/* Concatenate together a DDL to drop the table with prejudice. */
sql := 'DROP TRIGGER IF EXISTS '||row.trigger_name;
/* Execute the DDL statement. */
EXECUTE sql;
END LOOP;
/* Close the cursor. */
CLOSE trigger_cursor;
END;
$$;
/* Verify all tables are dropped. */
SELECT trigger_name
FROM information_schema.triggers
WHERE trigger_catalog = current_setting('videodb.catalog_name')
AND trigger_schema = 'public';
You can create a cleanup_catalog.sql script to call all four in sequence, like the following:
\i /home/student/Data/cit225/postgres/lib/utility/drop_tables.sql
\i /home/student/Data/cit225/postgres/lib/utility/drop_sequences.sql
\i /home/student/Data/cit225/postgres/lib/utility/drop_routines.sql
\i /home/student/Data/cit225/postgres/lib/utility/drop_triggers.sql |
\i /home/student/Data/cit225/postgres/lib/utility/drop_tables.sql
\i /home/student/Data/cit225/postgres/lib/utility/drop_sequences.sql
\i /home/student/Data/cit225/postgres/lib/utility/drop_routines.sql
\i /home/student/Data/cit225/postgres/lib/utility/drop_triggers.sql
The nice thing about this approach is that you won’t see any notices when tables, sequences, routines, or triggers aren’t found. It’s a clean approach to cleaning the schema for a testing environment.
While attempting an install of pgAdmin and updating a Fedora 30 environment, I encountered a conflict on the upgrade of MySQL 8.0.17-1 to 8.0.17.2. The community-mysql-8.0.17-2.fc30.x86_64 had conflicts with:
mysql-community-client-8.0.17-1.fc30.x86_64 packagemysql-community-server-8.0.17-1.fc30.x86_64 package
I tried to update the system before install pgadmin4 with the following syntax:
dnf -y update && dnf -y install pgadmin4 |
dnf -y update && dnf -y install pgadmin4
The dnf utility raise the following MySQL package errors during transaction checking:
Display detailed console log →
Error: Transaction check error:
file /usr/bin/mysql conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_config_editor conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqladmin conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlbinlog conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlcheck conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqldump conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlimport conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlpump conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlshow conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlslap conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/ibd2sdi conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/innochecksum conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/my_print_defaults conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisam_ftdump conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisamchk conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisamlog conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisampack conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_secure_installation conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_ssl_rsa_setup conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_tzinfo_to_sql conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_upgrade conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysqld_pre_systemd conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/perror conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib/systemd/system/mysqld.service conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib/systemd/system/mysqld@.service conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/adt_null.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/auth_socket.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_audit_api_message_emit.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_log_filter_dragnet.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_log_sink_json.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_log_sink_syseventlog.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_validate_password.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/connection_control.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/ddl_rewriter.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/group_replication.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/ha_example.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/ha_mock.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/innodb_engine.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/keyring_file.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/keyring_udf.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/libmemcached.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/locking_service.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/mypluglib.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/mysql_clone.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/mysql_no_login.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/rewrite_example.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/rewriter.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/semisync_master.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/semisync_slave.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/validate_password.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/version_token.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/sbin/mysqld conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /var/lib/mysql conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /var/lib/mysql-keyring conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/libmysqlclient.so.21.1.17 conflicts between attempted installs of community-mysql-libs-8.0.17-2.fc30.x86_64 and mysql-community-libs-8.0.17-1.fc30.x86_64 |
Error: Transaction check error:
file /usr/bin/mysql conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_config_editor conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqladmin conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlbinlog conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlcheck conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqldump conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlimport conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlpump conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlshow conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/mysqlslap conflicts between attempted installs of community-mysql-8.0.17-2.fc30.x86_64 and mysql-community-client-8.0.17-1.fc30.x86_64
file /usr/bin/ibd2sdi conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/innochecksum conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/my_print_defaults conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisam_ftdump conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisamchk conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisamlog conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/myisampack conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_secure_installation conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_ssl_rsa_setup conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_tzinfo_to_sql conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysql_upgrade conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/mysqld_pre_systemd conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/bin/perror conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib/systemd/system/mysqld.service conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib/systemd/system/mysqld@.service conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/adt_null.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/auth_socket.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_audit_api_message_emit.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_log_filter_dragnet.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_log_sink_json.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_log_sink_syseventlog.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/component_validate_password.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/connection_control.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/ddl_rewriter.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/group_replication.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/ha_example.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/ha_mock.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/innodb_engine.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/keyring_file.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/keyring_udf.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/libmemcached.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/locking_service.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/mypluglib.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/mysql_clone.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/mysql_no_login.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/rewrite_example.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/rewriter.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/semisync_master.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/semisync_slave.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/validate_password.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/plugin/version_token.so conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/sbin/mysqld conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /var/lib/mysql conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /var/lib/mysql-keyring conflicts between attempted installs of community-mysql-server-8.0.17-2.fc30.x86_64 and mysql-community-server-8.0.17-1.fc30.x86_64
file /usr/lib64/mysql/libmysqlclient.so.21.1.17 conflicts between attempted installs of community-mysql-libs-8.0.17-2.fc30.x86_64 and mysql-community-libs-8.0.17-1.fc30.x86_64
Since I’m not sure what’s wrong or how to fix it, I’ve put it in my queue of things to get to later. However, when I figure it out I’ll update this blog page with the solution or work around. If anybody knows the fix and would like to share, please let me know.
I removed the pending update packages with the following command:
Then, I simply installed pgadmin4 with the following command:
Display detailed console log →
Fedora Modular 30 - x86_64 24 kB/s | 17 kB 00:00
Fedora Modular 30 - x86_64 - Updates 26 kB/s | 15 kB 00:00
Fedora 30 - x86_64 - Updates 39 kB/s | 15 kB 00:00
Fedora 30 - x86_64 31 kB/s | 17 kB 00:00
google-chrome-unstable 12 kB/s | 1.3 kB 00:00
google-chrome 14 kB/s | 1.3 kB 00:00
MongoDB Repository 11 kB/s | 2.5 kB 00:00
MySQL 8.0 Community Server 10 kB/s | 2.5 kB 00:00
MySQL Connectors Community 13 kB/s | 2.5 kB 00:00
MySQL Tools Community 13 kB/s | 2.5 kB 00:00
PostgreSQL 11 30 - x86_64 1.5 kB/s | 3.8 kB 00:02
PostgreSQL 10 30 - x86_64 4.3 kB/s | 3.8 kB 00:00
PostgreSQL 9.6 30 - x86_64 10 kB/s | 3.8 kB 00:00
PostgreSQL 9.5 30 - x86_64 4.7 kB/s | 3.8 kB 00:00
PostgreSQL 9.4 30 - x86_64 8.4 kB/s | 3.8 kB 00:00
Dependencies resolved.
===============================================================================================================================================
Package Architecture Version Repository Size
===============================================================================================================================================
Installing:
pgadmin4 x86_64 4.12-1.f30 pgdg11 11 k
Installing dependencies:
python3-alembic noarch 1.0.10-1.fc30 updates 780 k
python3-paramiko noarch 2.5.0-1.fc30 updates 288 k
python3-sqlalchemy x86_64 1.3.7-1.fc30 updates 1.9 M
python3-bcrypt x86_64 3.1.4-7.fc30 fedora 41 k
python3-blinker noarch 1.4-4.fc30 fedora 113 k
python3-editor noarch 1.0.3-10.fc30 fedora 17 k
python3-flask noarch 1:1.0.2-4.fc30 fedora 154 k
python3-flask-babel noarch 0.11.2-4.fc30 fedora 53 k
python3-flask-babelex noarch 0.9.3-6.fc30 fedora 23 k
python3-flask-gravatar noarch 0.5.0-5.fc30 fedora 18 k
python3-flask-login noarch 0.4.1-5.fc30 fedora 34 k
python3-flask-mail noarch 0.9.1-7.fc30 fedora 22 k
python3-flask-paranoid noarch 0.2.0-6.fc30 fedora 13 k
python3-flask-principal noarch 0.4.0-19.fc30 fedora 19 k
python3-flask-security noarch 3.0.0-5.fc30 fedora 82 k
python3-flask-sqlalchemy noarch 2.3.2-4.fc30 fedora 116 k
python3-flask-wtf noarch 0.14.2-4.fc30 fedora 67 k
python3-htmlmin noarch 0.1.12-7.git220b1d1.fc30 fedora 61 k
python3-itsdangerous noarch 0.24-16.fc30 fedora 28 k
python3-linecache2 noarch 1.0.0-18.fc30 fedora 17 k
python3-mod_wsgi x86_64 4.6.4-3.fc30 fedora 5.6 M
python3-passlib noarch 1.7.1-2.fc30 fedora 741 k
python3-pynacl x86_64 1.3.0-1.fc30 fedora 96 k
python3-speaklater noarch 1.3-15.fc30 fedora 15 k
python3-sqlparse noarch 0.2.4-5.fc30 fedora 79 k
python3-traceback2 noarch 1.4.0-19.fc30 fedora 23 k
python3-unittest2 noarch 1.1.0-16.fc30 fedora 183 k
python3-werkzeug noarch 0.14.1-7.fc30 fedora 465 k
python3-wtforms noarch 2.2.1-4.fc30 fedora 188 k
pgadmin4-docs noarch 4.12-1.f30 pgdg11 32 M
pgadmin4-python3-flask-htmlmin noarch 1.5.0-1.f30 pgdg11 13 k
pgadmin4-python3-flask-migrate noarch 2.4.0-1.f30 pgdg11 28 k
pgadmin4-python3-psutil x86_64 5.5.1-1.f30 pgdg11 375 k
pgadmin4-python3-six noarch 1.12.0-3.f30 pgdg11 35 k
pgadmin4-python3-sshtunnel noarch 0.1.4-1.f30 pgdg11 46 k
pgadmin4-python3-werkzeug noarch 0.15.4-1.f30 pgdg11 463 k
pgadmin4-pytz noarch 2018.9-1.f30 pgdg11 52 k
pgadmin4-web noarch 4.12-1.f30 pgdg11 5.4 M
python3-psycopg2 x86_64 2.8.3-1.f30 pgdg11 168 k
Transaction Summary
===============================================================================================================================================
Install 40 Packages
Total download size: 50 M
Installed size: 109 M
Downloading Packages:
(1/40): python3-paramiko-2.5.0-1.fc30.noarch.rpm 179 kB/s | 288 kB 00:01
(2/40): python3-alembic-1.0.10-1.fc30.noarch.rpm 401 kB/s | 780 kB 00:01
(3/40): python3-sqlalchemy-1.3.7-1.fc30.x86_64.rpm 927 kB/s | 1.9 MB 00:02
(4/40): python3-bcrypt-3.1.4-7.fc30.x86_64.rpm 47 kB/s | 41 kB 00:00
(5/40): python3-flask-1.0.2-4.fc30.noarch.rpm 697 kB/s | 154 kB 00:00
(6/40): python3-editor-1.0.3-10.fc30.noarch.rpm 26 kB/s | 17 kB 00:00
(7/40): python3-blinker-1.4-4.fc30.noarch.rpm 128 kB/s | 113 kB 00:00
(8/40): python3-flask-babel-0.11.2-4.fc30.noarch.rpm 435 kB/s | 53 kB 00:00
(9/40): python3-flask-babelex-0.9.3-6.fc30.noarch.rpm 139 kB/s | 23 kB 00:00
(10/40): python3-flask-gravatar-0.5.0-5.fc30.noarch.rpm 175 kB/s | 18 kB 00:00
(11/40): python3-flask-login-0.4.1-5.fc30.noarch.rpm 172 kB/s | 34 kB 00:00
(12/40): python3-flask-mail-0.9.1-7.fc30.noarch.rpm 210 kB/s | 22 kB 00:00
(13/40): python3-flask-paranoid-0.2.0-6.fc30.noarch.rpm 64 kB/s | 13 kB 00:00
(14/40): python3-flask-principal-0.4.0-19.fc30.noarch.rpm 172 kB/s | 19 kB 00:00
(15/40): python3-flask-security-3.0.0-5.fc30.noarch.rpm 379 kB/s | 82 kB 00:00
(16/40): python3-flask-sqlalchemy-2.3.2-4.fc30.noarch.rpm 534 kB/s | 116 kB 00:00
(17/40): python3-flask-wtf-0.14.2-4.fc30.noarch.rpm 295 kB/s | 67 kB 00:00
(18/40): python3-htmlmin-0.1.12-7.git220b1d1.fc30.noarch.rpm 290 kB/s | 61 kB 00:00
(19/40): python3-itsdangerous-0.24-16.fc30.noarch.rpm 253 kB/s | 28 kB 00:00
(20/40): python3-linecache2-1.0.0-18.fc30.noarch.rpm 87 kB/s | 17 kB 00:00
(21/40): python3-pynacl-1.3.0-1.fc30.x86_64.rpm 152 kB/s | 96 kB 00:00
(22/40): python3-passlib-1.7.1-2.fc30.noarch.rpm 897 kB/s | 741 kB 00:00
(23/40): python3-mod_wsgi-4.6.4-3.fc30.x86_64.rpm 4.8 MB/s | 5.6 MB 00:01
(24/40): python3-speaklater-1.3-15.fc30.noarch.rpm 34 kB/s | 15 kB 00:00
(25/40): python3-sqlparse-0.2.4-5.fc30.noarch.rpm 242 kB/s | 79 kB 00:00
(26/40): python3-traceback2-1.4.0-19.fc30.noarch.rpm 211 kB/s | 23 kB 00:00
(27/40): python3-unittest2-1.1.0-16.fc30.noarch.rpm 785 kB/s | 183 kB 00:00
(28/40): python3-werkzeug-0.14.1-7.fc30.noarch.rpm 1.0 MB/s | 465 kB 00:00
(29/40): python3-wtforms-2.2.1-4.fc30.noarch.rpm 574 kB/s | 188 kB 00:00
(30/40): pgadmin4-4.12-1.f30.x86_64.rpm 12 kB/s | 11 kB 00:00
(31/40): pgadmin4-python3-flask-htmlmin-1.5.0-1.f30.noarch.rpm 15 kB/s | 13 kB 00:00
(32/40): pgadmin4-python3-flask-migrate-2.4.0-1.f30.noarch.rpm 68 kB/s | 28 kB 00:00
(33/40): pgadmin4-python3-six-1.12.0-3.f30.noarch.rpm 165 kB/s | 35 kB 00:00
(34/40): pgadmin4-python3-sshtunnel-0.1.4-1.f30.noarch.rpm 215 kB/s | 46 kB 00:00
(35/40): pgadmin4-python3-psutil-5.5.1-1.f30.x86_64.rpm 343 kB/s | 375 kB 00:01
(36/40): pgadmin4-pytz-2018.9-1.f30.noarch.rpm 242 kB/s | 52 kB 00:00
(37/40): pgadmin4-python3-werkzeug-0.15.4-1.f30.noarch.rpm 234 kB/s | 463 kB 00:01
(38/40): python3-psycopg2-2.8.3-1.f30.x86_64.rpm 263 kB/s | 168 kB 00:00
(39/40): pgadmin4-web-4.12-1.f30.noarch.rpm 1.1 MB/s | 5.4 MB 00:04
(40/40): pgadmin4-docs-4.12-1.f30.noarch.rpm 1.2 MB/s | 32 MB 00:26
-----------------------------------------------------------------------------------------------------------------------------------------------
Total 1.5 MB/s | 50 MB 00:32
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : python3-speaklater-1.3-15.fc30.noarch 1/40
Installing : python3-itsdangerous-0.24-16.fc30.noarch 2/40
Installing : python3-blinker-1.4-4.fc30.noarch 3/40
Installing : python3-sqlalchemy-1.3.7-1.fc30.x86_64 4/40
Installing : python3-wtforms-2.2.1-4.fc30.noarch 5/40
Installing : python3-passlib-1.7.1-2.fc30.noarch 6/40
Installing : python3-psycopg2-2.8.3-1.f30.x86_64 7/40
Installing : pgadmin4-pytz-2018.9-1.f30.noarch 8/40
Installing : pgadmin4-python3-werkzeug-0.15.4-1.f30.noarch 9/40
Installing : pgadmin4-python3-six-1.12.0-3.f30.noarch 10/40
Installing : pgadmin4-python3-psutil-5.5.1-1.f30.x86_64 11/40
Installing : pgadmin4-docs-4.12-1.f30.noarch 12/40
Installing : python3-werkzeug-0.14.1-7.fc30.noarch 13/40
Installing : python3-flask-1:1.0.2-4.fc30.noarch 14/40
Installing : python3-flask-babel-0.11.2-4.fc30.noarch 15/40
Installing : python3-flask-babelex-0.9.3-6.fc30.noarch 16/40
Installing : python3-flask-login-0.4.1-5.fc30.noarch 17/40
Installing : python3-flask-mail-0.9.1-7.fc30.noarch 18/40
Installing : python3-flask-principal-0.4.0-19.fc30.noarch 19/40
Installing : python3-flask-wtf-0.14.2-4.fc30.noarch 20/40
Installing : python3-flask-security-3.0.0-5.fc30.noarch 21/40
Installing : python3-flask-gravatar-0.5.0-5.fc30.noarch 22/40
Installing : python3-flask-paranoid-0.2.0-6.fc30.noarch 23/40
Installing : python3-flask-sqlalchemy-2.3.2-4.fc30.noarch 24/40
Installing : pgadmin4-python3-flask-migrate-2.4.0-1.f30.noarch 25/40
Installing : python3-sqlparse-0.2.4-5.fc30.noarch 26/40
Installing : python3-pynacl-1.3.0-1.fc30.x86_64 27/40
Installing : python3-mod_wsgi-4.6.4-3.fc30.x86_64 28/40
Installing : python3-linecache2-1.0.0-18.fc30.noarch 29/40
Installing : python3-traceback2-1.4.0-19.fc30.noarch 30/40
Installing : python3-unittest2-1.1.0-16.fc30.noarch 31/40
Installing : python3-htmlmin-0.1.12-7.git220b1d1.fc30.noarch 32/40
Installing : pgadmin4-python3-flask-htmlmin-1.5.0-1.f30.noarch 33/40
Installing : python3-editor-1.0.3-10.fc30.noarch 34/40
Installing : python3-alembic-1.0.10-1.fc30.noarch 35/40
Installing : python3-bcrypt-3.1.4-7.fc30.x86_64 36/40
Installing : python3-paramiko-2.5.0-1.fc30.noarch 37/40
Installing : pgadmin4-python3-sshtunnel-0.1.4-1.f30.noarch 38/40
Installing : pgadmin4-web-4.12-1.f30.noarch 39/40
Installing : pgadmin4-4.12-1.f30.x86_64 40/40
Running scriptlet: pgadmin4-4.12-1.f30.x86_64 40/40
Verifying : python3-alembic-1.0.10-1.fc30.noarch 1/40
Verifying : python3-paramiko-2.5.0-1.fc30.noarch 2/40
Verifying : python3-sqlalchemy-1.3.7-1.fc30.x86_64 3/40
Verifying : python3-bcrypt-3.1.4-7.fc30.x86_64 4/40
Verifying : python3-blinker-1.4-4.fc30.noarch 5/40
Verifying : python3-editor-1.0.3-10.fc30.noarch 6/40
Verifying : python3-flask-1:1.0.2-4.fc30.noarch 7/40
Verifying : python3-flask-babel-0.11.2-4.fc30.noarch 8/40
Verifying : python3-flask-babelex-0.9.3-6.fc30.noarch 9/40
Verifying : python3-flask-gravatar-0.5.0-5.fc30.noarch 10/40
Verifying : python3-flask-login-0.4.1-5.fc30.noarch 11/40
Verifying : python3-flask-mail-0.9.1-7.fc30.noarch 12/40
Verifying : python3-flask-paranoid-0.2.0-6.fc30.noarch 13/40
Verifying : python3-flask-principal-0.4.0-19.fc30.noarch 14/40
Verifying : python3-flask-security-3.0.0-5.fc30.noarch 15/40
Verifying : python3-flask-sqlalchemy-2.3.2-4.fc30.noarch 16/40
Verifying : python3-flask-wtf-0.14.2-4.fc30.noarch 17/40
Verifying : python3-htmlmin-0.1.12-7.git220b1d1.fc30.noarch 18/40
Verifying : python3-itsdangerous-0.24-16.fc30.noarch 19/40
Verifying : python3-linecache2-1.0.0-18.fc30.noarch 20/40
Verifying : python3-mod_wsgi-4.6.4-3.fc30.x86_64 21/40
Verifying : python3-passlib-1.7.1-2.fc30.noarch 22/40
Verifying : python3-pynacl-1.3.0-1.fc30.x86_64 23/40
Verifying : python3-speaklater-1.3-15.fc30.noarch 24/40
Verifying : python3-sqlparse-0.2.4-5.fc30.noarch 25/40
Verifying : python3-traceback2-1.4.0-19.fc30.noarch 26/40
Verifying : python3-unittest2-1.1.0-16.fc30.noarch 27/40
Verifying : python3-werkzeug-0.14.1-7.fc30.noarch 28/40
Verifying : python3-wtforms-2.2.1-4.fc30.noarch 29/40
Verifying : pgadmin4-4.12-1.f30.x86_64 30/40
Verifying : pgadmin4-docs-4.12-1.f30.noarch 31/40
Verifying : pgadmin4-python3-flask-htmlmin-1.5.0-1.f30.noarch 32/40
Verifying : pgadmin4-python3-flask-migrate-2.4.0-1.f30.noarch 33/40
Verifying : pgadmin4-python3-psutil-5.5.1-1.f30.x86_64 34/40
Verifying : pgadmin4-python3-six-1.12.0-3.f30.noarch 35/40
Verifying : pgadmin4-python3-sshtunnel-0.1.4-1.f30.noarch 36/40
Verifying : pgadmin4-python3-werkzeug-0.15.4-1.f30.noarch 37/40
Verifying : pgadmin4-pytz-2018.9-1.f30.noarch 38/40
Verifying : pgadmin4-web-4.12-1.f30.noarch 39/40
Verifying : python3-psycopg2-2.8.3-1.f30.x86_64 40/40
Installed:
pgadmin4-4.12-1.f30.x86_64 python3-alembic-1.0.10-1.fc30.noarch
python3-paramiko-2.5.0-1.fc30.noarch python3-sqlalchemy-1.3.7-1.fc30.x86_64
python3-bcrypt-3.1.4-7.fc30.x86_64 python3-blinker-1.4-4.fc30.noarch
python3-editor-1.0.3-10.fc30.noarch python3-flask-1:1.0.2-4.fc30.noarch
python3-flask-babel-0.11.2-4.fc30.noarch python3-flask-babelex-0.9.3-6.fc30.noarch
python3-flask-gravatar-0.5.0-5.fc30.noarch python3-flask-login-0.4.1-5.fc30.noarch
python3-flask-mail-0.9.1-7.fc30.noarch python3-flask-paranoid-0.2.0-6.fc30.noarch
python3-flask-principal-0.4.0-19.fc30.noarch python3-flask-security-3.0.0-5.fc30.noarch
python3-flask-sqlalchemy-2.3.2-4.fc30.noarch python3-flask-wtf-0.14.2-4.fc30.noarch
python3-htmlmin-0.1.12-7.git220b1d1.fc30.noarch python3-itsdangerous-0.24-16.fc30.noarch
python3-linecache2-1.0.0-18.fc30.noarch python3-mod_wsgi-4.6.4-3.fc30.x86_64
python3-passlib-1.7.1-2.fc30.noarch python3-pynacl-1.3.0-1.fc30.x86_64
python3-speaklater-1.3-15.fc30.noarch python3-sqlparse-0.2.4-5.fc30.noarch
python3-traceback2-1.4.0-19.fc30.noarch python3-unittest2-1.1.0-16.fc30.noarch
python3-werkzeug-0.14.1-7.fc30.noarch python3-wtforms-2.2.1-4.fc30.noarch
pgadmin4-docs-4.12-1.f30.noarch pgadmin4-python3-flask-htmlmin-1.5.0-1.f30.noarch
pgadmin4-python3-flask-migrate-2.4.0-1.f30.noarch pgadmin4-python3-psutil-5.5.1-1.f30.x86_64
pgadmin4-python3-six-1.12.0-3.f30.noarch pgadmin4-python3-sshtunnel-0.1.4-1.f30.noarch
pgadmin4-python3-werkzeug-0.15.4-1.f30.noarch pgadmin4-pytz-2018.9-1.f30.noarch
pgadmin4-web-4.12-1.f30.noarch python3-psycopg2-2.8.3-1.f30.x86_64
Complete!
The pgadmin4 configuration instructions can be found for several Linux versions at Josphat Mutai’s Computing for Geeks web page. On Fedora 30, you need to do the following:
- Install, start, and enable Apache as the
httpd service unless you already have done that.
- Copy the
/etc/httpd/conf.d/pgadmin4.conf.sample file to /etc/httpd/conf.d/pgadmin4.conf, which is a new file.
- Restart the
httpd service to incorporate the pgadmin4 configuration file.
After that, you create the following new directories as the root or sudo user:
/var/lib/pgadmin4/var/log/pgadmin4
You can make both directories with a single mkdir command, like:
mkdir -p /var/lib/pgadmin4 /var/log/pgadmin4 |
mkdir -p /var/lib/pgadmin4 /var/log/pgadmin4
As the root or sudo user, change the ownership of these two directories to the apache user with the following syntax:
chown -R apache:apache /var/lib/pgadmin4 /var/log/pgadmin4 |
chown -R apache:apache /var/lib/pgadmin4 /var/log/pgadmin4
You add the following four statements to the config_distro.py file in the /usr/lib/python3.7/site-packages/pgadmin4-web directory as the root or sudo user:
LOG_FILE = '/var/log/pgadmin4/pgadmin4.log'
SQLITE_PATH = '/var/lib/pgadmin4/pgadmin4.db'
SESSION_DB_PATH = '/var/lib/pgadmin4/sessions'
STORAGE_DIR = '/var/lib/pgadmin4/storage' |
LOG_FILE = '/var/log/pgadmin4/pgadmin4.log'
SQLITE_PATH = '/var/lib/pgadmin4/pgadmin4.db'
SESSION_DB_PATH = '/var/lib/pgadmin4/sessions'
STORAGE_DIR = '/var/lib/pgadmin4/storage'
You need to setup the pgadmin user with the following python3 command:
python3 /usr/lib/python3.7/site-packages/pgadmin4-web/setup.py |
python3 /usr/lib/python3.7/site-packages/pgadmin4-web/setup.py
Enter the following values, a real email address and a password twice:
NOTE: Configuring authentication for SERVER mode.
Enter the email address and password to use for the initial pgAdmin user account:
Email address: admin@example.com
Password: your_password
Retype password: your_password
pgAdmin 4 - Application Initialisation
====================================== |
NOTE: Configuring authentication for SERVER mode.
Enter the email address and password to use for the initial pgAdmin user account:
Email address: admin@example.com
Password: your_password
Retype password: your_password
pgAdmin 4 - Application Initialisation
======================================
Assuming you have an enabled firewall, you need to issue the following two commands as the root or sudo user:
rirewall-cmd --permanent --add-service=http
firewall-cmd --reload |
rirewall-cmd --permanent --add-service=http
firewall-cmd --reload
You invoke pgAdmin4 from within a browser window with the following URL for a stand alone workstation (for a workstation on a DNS network you would enter pgadmin.domain.domain_type in lieu of localhost):
pgadmin/localhost/pgadmin4 |
pgadmin/localhost/pgadmin4
You most likely will encounter an Internal Server Error, the recommended fix is reputed to be:
ausearch -c 'httpd' --raw | audit2allow -M my-httpd
semodule -X 300 -i my-httpd.pp |
ausearch -c 'httpd' --raw | audit2allow -M my-httpd
semodule -X 300 -i my-httpd.pp
It didn’t work for me. At the end of the process, I have an Internal Server Error. It is something that I’ll try to fix next. The actual error message:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at root@localhost to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log. |
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at root@localhost to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
If somebody figures out the last step before I do, that’s great. Let me and everybody else know the mystery.
On a positive note, the pgadmin4 package provided the psycopg2 library. I had looked for it as a psycopg2 package but it is in python3-psycopg2 package.
Subscribe via RSS