ramfs_based_table_space
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
ramfs_based_table_space [2012/03/23 19:39] k2patel |
ramfs_based_table_space [2012/03/23 19:41] k2patel [Automating the process] |
||
|---|---|---|---|
| Line 79: | Line 79: | ||
| - | == Dump database schema: == | + | == Dump database schema: == |
| <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 95: | Line 95: | ||
| - | == Mount ramfs: == | + | == Mount ramfs: == |
| Line 105: | Line 105: | ||
| </code> | </code> | ||
| - | == Recreate PostgreSQL tablespace directory: == | + | == Recreate PostgreSQL tablespace directory: == |
| Line 116: | Line 116: | ||
| - | == 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 124: | Line 124: | ||
| </code> | </code> | ||
| | | ||
| - | == Restore the database schema: == | + | == Restore the database schema: == |
| | | ||
ramfs_based_table_space.txt · Last modified: 2020/08/10 02:35 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
