Installation Download https://pgpool.net/mediawiki/index.php/Downloads Compile and install tar -zxvf pgpool-II-4.4.4.tar.gz cd pgpool-II-4.4.4.tar.gz ./configure –prefix=/usr/local/pgpool –with-pgsql=/usr/local/postgres/ make & amp; & amp; make install #pgpool-regclass plug-in installation cd /root/pgpool-II-4.4.4/src/sql/pgpool-regclass make & amp; & amp; make install psql -h /data/pgdata/tmp -p 4567 -U postgres -f pgpool-regclass.sql template1 # The following test is not executed ln -s /root/pgpool-II-4.4.4//src/sql/pgpool-regclass/* /usr/local/postgres/lib/ # […]
Tag: pgp
Playing with gpgpu-sim 04 notes–What exactly does __cudaRegisterBinary() of gpgpu-sim do?
1. Refer to __cudaRegisterFatBinary of nv The implementation of this function of nv is hidden in cuda sdk, but the calling source code of this function is in the installed header file of nv cuda sdk; For example, the source code called in cuda 12.1 is as follows: #define __cudaRegisterBinary(X) \ __cudaFatCubinHandle = __cudaRegisterFatBinary((void*) & […]
MACOS pulsar astronomy software installation psrcat pgplot tempo tempo2 psrchive etc.
What needs to be installed includes pgplot, psrcat, tempo, tmepo2, psrchive, etc. Preparation Set path: The terminal I use is iterm, fancy, colorful, good positioning, I like it. Based on the backwardness of various astronomical software, it is basically necessary to manually set the path to call successfully. I put all downloaded astronomy software into […]
openEuler installs pgpool+pg+gis offline to achieve high availability
openEuler installs pgpool-II + postgresql to achieve high database availability Precautions, compilation errors may be caused by the environment and lib dependencies not being found Be careful not to configure all environments and lib dependencies at once, and then configure the corresponding item after installing a certain item 1. Environment variables: Add the corresponding configuration […]
nVidia GPGPU vs AMD Radeon HD Graphics execution mode comparison
Everyone who is a friend of high-performance computing must be very familiar with the execution mode of the CPU. Contemporary advanced CPUs generally use superscalar pipelines to enable parallel execution of several adjacent mutually independent instructions-this is called instruction set parallelism (ILP, Instruction-Level Parallelism); and SSE (Streaming SIMD Extension) introduced by x86 , AVX (Advanced […]
[GPGPU programming] Predicate register of GPGPU architecture analysis
Article directory concept effect architecture design how to use? how conditional execution Do different things for odd and even threads conditional assignment Perform different operations on arrays Classification Precautions (when programming) We know that the CPU can control the conditional execution of the program, and GPGPU also supports the conditional execution of the thread, but […]
pgpool-II PostgreSQL load balancing middleware
Tip: After the article is written, the table of contents can be automatically generated. How to generate it can refer to the help document on the right pgpool-II PostgreSQL load balancing middleware foreword 1. What is pgpool-II? 2. Environment install postgresql 14.7 Open the access port to the IP outside the machine Change the password […]
too strong! ChatpGPT + Spring to generate images
Because the official account has changed the push rules, please click “Looking” and add “Star” to get exciting technology sharing as soon as possible Click to follow #Internet Architect Public Account, and get a full set of architect information here
Network security experiment – the use of pgp
Network security experiment – the use of pgp Experiment requirements ① Use pgp software as a group of three to four people to complete key generation, public key publication, use pgp to protect data and transmit it, and verify signatures. ② Here I use GnuPG Principle of the experiment PGP PGP (English: Pretty Good Privacy, […]
[Solved] pgpool-II common errors
Items in 1 pg_hba do not match Suppose you have 2 nodes in your pgpool cluster and you update the pg_hba.conf entry in one of the nodes, but forget to apply the same entry on the other node, you will see an error like this: psql -d postgres -U postgres -h 127.0.0.1 -p 5432 -c […]