26 releases

Uses old Rust 2015

0.6.3 Sep 18, 2024
0.6.1 Jun 11, 2024
0.5.0 Jan 19, 2024
0.4.8 Apr 18, 2023
0.2.0 Nov 21, 2015

#30 in Database interfaces

Download history 68298/week @ 2024-08-23 69336/week @ 2024-08-30 68857/week @ 2024-09-06 64155/week @ 2024-09-13 70267/week @ 2024-09-20 74616/week @ 2024-09-27 68187/week @ 2024-10-04 72927/week @ 2024-10-11 82697/week @ 2024-10-18 84808/week @ 2024-10-25 75651/week @ 2024-11-01 75512/week @ 2024-11-08 76295/week @ 2024-11-15 68896/week @ 2024-11-22 73076/week @ 2024-11-29 61118/week @ 2024-12-06

292,879 downloads per month
Used in 270 crates (4 directly)

MIT/Apache

1MB
20K SLoC

C 10K SLoC // 0.3% comments Rust 7K SLoC // 0.0% comments PO File 2.5K SLoC // 0.5% comments Perl 596 SLoC // 0.2% comments

pq-sys

Autogenerated Rust bindings for libpq https://docs.rs/pq-sys/latest/pq_sys/

Building

This repository contains direct, one-to-one mappings to the C functions provided in libpq-fe.h and postgres_ext.h. This library expects that libpq be installed on the system.

The build script of crate will attempt to find the lib path of libpq using the following methods:

  • First it will look for an environment variable in the format of PQ_LIB_DIR_{TARGET} where {TARGET} gets replaced by the Target environment variable set for cross-compilation
  • Second, if the environment variable PQ_LIB_DIR is set, it will use its value
  • If the environment variable isn't set, it tries to use pkg-config to locate it. All the config options, such as PKG_CONFIG_ALLOW_CROSS, PKG_CONFIG_ALL_STATIC etc., of the crate pkg-config apply.
  • Then, for MSVC ABI builds the build script will attempt use the library from a vcpkg installation if there is one available. You may need to set VCPKG_ROOT (or run vcpkg integrate install), set VCPKGRS_DYNAMIC=1, and run vcpkg install libpq:x64-windows. See the documentation for the vcpkg crate for more.
  • If it still can't locate the library, it will invoke the Postgres command pg_config --libdir

The build script instructs Cargo to link the library statically if the environmental variable PQ_LIB_STATIC is set. This can be useful, if targeting for a musl target. If pkg-config is being used, it's configuration options will apply.

Features

  • buildtime_bindgen: Run bindgen at build-time to generate bindings using installed headers. Not compatible with the bundled feature.
  • bundled: Build the bundled version of libpq from source. It will look for openssl installed on your system. To use a bundled version of openssl, add the openssl-sys crate with the vendored feature to your crate dependencies:
    [dependencies]
    openssl-sys = { version = "0.9.93", features = ["vendored"] }
    
  • bundled_without_openssl: Build the bundled version of libpq from source without openssl. This disables the TLS support in libpq, so that you cannot connect to a database requiring TLS anymore.

FAQ

I'm seeing dyld: Symbol not found __cg_jpeg_resync_to_restart on macOS

This is caused when the output of pg_config --libdir is a directory that also contains libjpeg.dylib which differs from the system libjpeg. This is usually caused by install postgres via homebrew, or using postgresapp.com.

If you've installed via homebrew, you should not see this issue unless you've provided features = ["pkg-config"]. You can work around the issue by exporting PQ_LIB_DIR="$(brew --prefix postgres)/lib".

If you've installed postgresql using postgresapp.com, you will not be able to run your binaries using cargo run or cargo test. You can compile the binary manually via cargo build and then run /target/debug/yourapp. You can also manually create a directory that contains only a symlink to libpq.dylib and nothing else, then export PQ_LIB_DIR to that directory. It is recommended that you do not use postgresapp.com.

License

Licensed under either of

at your option.

Contribution

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.

Dependencies