![]() ![]() Psql> select oid, datname from pg_database You can see the correspondence by executing the following query: If you are curious about the directory naming scheme, the numbers correspond to the OIDs (object ids) of the corresponding rows in the pg_database table. Notice that I have three subdirectories underneath the base directory?that's because I have three databases. The data/base directory is where your databases live. This snapshot shows a typical installation of PostgreSQL release 7.1.3. You may see more files and subdirectories if you are running a different version of PostgreSQL. The data directory contains three subdirectories: base, global, and pg_xlog. The directory structure of a PostgreSQL installation. Figure 21.1 gives you a look at the structure. Let's start by looking at the directory structure of a PostgreSQL installation. PostgreSQL uses the $PGDATA environment variable to find its data files. I'll refer to this last directory as $PGDATA. If you have a typical installation, you can expect to find data files: databases, configuration, and security information in / usr/local/pgsql/data. Executables (such as psql, initdb, and the postmaster) are often installed in the /usr/local/pgsql/bin directory. PostgreSQL is typically installed in the /usr/local/pgsql directory. Zlib x86_64 1.2.7-19.The first step in securing a PostgreSQL installation is to secure the actual data files that comprise each database. Readline.x86_64 ~]# yum install -y zlib-devel No Presto metadata available for ol7_latest ![]() > Package readline.x86_64 0:6.2-11.el7 will be an update > Package ncurses-devel.x86_64 0:5.7_4 will be installed > Processing Dependency: ncurses-devel for package: 86_64 > Processing Dependency: readline = 6.2-11.el7 for package: 86_64 ![]() > Package readline-devel.x86_64 0:6.2-11.el7 will be installed Search ~]# ~]# yum install readline-devel How to START/STOP PostgreSQL 13 on Linux.Install PostgreSQL 13 using yum Repository on Linux.Add Targets Manually on EM Cloud Control 13c.Rolling Upgrade With an Existing Physical Standby Database.Upgrade Oracle Database Manually from 12.2.0.1 to 19c.Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA.How to Change MAX_STRING_SIZE on Physical Standby Environment.Create Non-CDB on Oracle 12c using DBCA (GUI).CREATE NON-CDB ON ORACLE 12C IN SILENT MODE.CREATE NEW PDB BY CLONING AN EXISTING PDB. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |