Debian DokuWiki

User Tools

Site Tools

Trace: • add_ssh_key_to_multiple_host • building_mariadb_on_freebsd • oracle_coherence • tuneup_guide • snapshot_backup • upgrade_using_ius • bash • apache
ramfs_based_table_space

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
ramfs_based_table_space [2012/03/23 19:40] – [Automating the process] k2patelramfs_based_table_space [2020/08/10 02:35] (current) – external edit 127.0.0.1
Line 8: Line 8:
  
  
-    Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files \\ +Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files \\ 
-    representing database objects can be stored. Once created, a tablespace can be referred to by name when creating \\ +representing database objects can be stored. Once created, a tablespace can be referred to by name when creating \\ 
-    database objects.The location must be an existing, empty directory that is owned by the PostgreSQL system user. \\ +database objects.The location must be an existing, empty directory that is owned by the PostgreSQL system user. \\ 
-    All objects subsequently created within the tablespace will be stored in files underneath this directory. \\ +All objects subsequently created within the tablespace will be stored in files underneath this directory. \\ 
-    Creation of the tablespace itself must be done as a database superuser, but after that you can allow ordinary \\ +Creation of the tablespace itself must be done as a database superuser, but after that you can allow ordinary \\ 
-    database users to make use of it. To do that, grant them the CREATE privilege on it. +database users to make use of it. To do that, grant them the CREATE privilege on it. 
  
 First create the directory where tablespace will be stored. It must reside on your ramfs filesystem. First create the directory where tablespace will be stored. It must reside on your ramfs filesystem.
Line 82: Line 82:
  
 <code bash> <code bash>
-         pg_dump --create --schema-only --file=/root/memdb.sql --host=localhost -U postgres memdb+  pg_dump --create --schema-only --file=/root/memdb.sql --host=localhost -U postgres memdb
 </code>          </code>         
  
-    Stop postmaster (original init code) +Stop postmaster (original init code) 
-    Unmount ramfs: +== Unmount ramfs: == 
-    +   
 <code bash> <code bash>
          umount /mnt/ramfs          umount /mnt/ramfs
Line 118: Line 118:
 == Start postmaster (original init code) == == Start postmaster (original init code) ==
  
-    Drop the database because it exists in PostgreSQL system tables only.+Drop the database because it exists in PostgreSQL system tables only.
  
 <code bash> <code bash>
Line 136: Line 136:
 You have just learned how to set up memory storage for the PostgreSQL database server. \\ You have just learned how to set up memory storage for the PostgreSQL database server. \\
  
 +[[http://magazine.redhat.com/2007/12/12/tip-from-an-rhce-memory-storage-on-postgresql/ | Referance]]
ramfs_based_table_space.1332531622.txt.gz · Last modified: 2020/08/10 02:29 (external edit)