Skip to content

password profile documentation #12

Description

@mkurtoglu

installation in readme not clearly working . we follow below steps. Update readme file

sudo dnf install -y epel-release
sudo dnf config-manager --set-enabled crb
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf install -y postgresql17 postgresql17-server postgresql17-devel postgresql17-contrib
sudo dnf install -y openssl-devel krb5-devel pkgconf-pkg-config

dnf update -y

curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs/ | sh -s -- -y
source "$HOME/.cargo/env"
cargo install --locked cargo-pgrx --version 0.16.1
cargo pgrx init --pg17 /usr/pgsql-17/bin/pg_config

dnf install git -y
git clone https://github.com/bisoftbilgi/bisoft-postgresql-toolkit.git
cd bisoft-postgresql-toolkit/password_profile
git checkout test1

export PG_CONFIG=/usr/pgsql-17/bin/pg_config
cargo pgrx package --pg-config /usr/pgsql-17/bin/pg_config
sudo cp -r target/release/password_profile-pg17/usr/pgsql-17/* /usr/pgsql-17/

sudo cp blacklist.txt /var/lib/pgsql/17/data/password_profile_blacklist.txt
sudo chown postgres:postgres /var/lib/pgsql/17/data/password_profile_blacklist.txt

psql
create extension password_profile;

vi postgresql.conf
shared_preload_library='password_profile'

restart postgresql

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions