https://wiki.cs.earlham.edu/index.php?action=history&feed=atom&title=Changing_Data_Directory 2026-08-10T04:46:16Z Revision history for this page on the wiki MediaWiki 1.44.2 https://wiki.cs.earlham.edu/index.php?title=Changing_Data_Directory&diff=17110&oldid=prev 2019-05-24T15:09:24Z

<p>Blanked the page</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:09, 24 May 2019</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">1. Shut down PostgreSQL</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">:/usr/&lt;postgres folder&gt;/bin/pg_ctl stop -D /var/lib/pgsql/&lt;version&gt;/main/data</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D var/lib/pgsql/9.1/main/data</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">2. Make sure that PostgreSQL has been shut down successfully</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">:/usr/&lt;postgres folder&gt;/bin/pg_ctl status -D /var/lib/postgresql/&lt;version&gt;/main/data</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">3. Find the PostgreSQL config file and edit it (usually in /etc/postgresql, but it might be in /var)</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">:nano /etc/postgresql/&lt;version&gt;/main/postgresql.conf</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">:change the data_directory, pg_hba, and pg_ident lines to the new paths</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4. Change ownership of the new directory and subdirectories to make sure postgres user has access to those</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">:sudo chown -R &lt;ownername&gt;:&lt;groupname&gt; &lt;foldername&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">5. Restart PostgreSQL</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">:/usr/&lt;postgres folder&gt;/bin/pg_ctl start -D &lt;new path&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">:/usr/&lt;postgres folder&gt;/bin/pg_ctl status -D &lt;new path&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> </table>

Ktnguyen17 https://wiki.cs.earlham.edu/index.php?title=Changing_Data_Directory&diff=17108&oldid=prev 2019-05-24T15:06:31Z

<p>Created page with &quot;1. Shut down PostgreSQL :/usr/&lt;postgres folder&gt;/bin/pg_ctl stop -D /var/lib/pgsql/&lt;version&gt;/main/data ::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D var/lib/pgsql/9.1/main/data...&quot;</p> <p><b>New page</b></p><div>1. Shut down PostgreSQL<br /> :/usr/&lt;postgres folder&gt;/bin/pg_ctl stop -D /var/lib/pgsql/&lt;version&gt;/main/data<br /> ::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D var/lib/pgsql/9.1/main/data<br /> 2. Make sure that PostgreSQL has been shut down successfully<br /> :/usr/&lt;postgres folder&gt;/bin/pg_ctl status -D /var/lib/postgresql/&lt;version&gt;/main/data<br /> 3. Find the PostgreSQL config file and edit it (usually in /etc/postgresql, but it might be in /var)<br /> :nano /etc/postgresql/&lt;version&gt;/main/postgresql.conf<br /> :change the data_directory, pg_hba, and pg_ident lines to the new paths<br /> 4. Change ownership of the new directory and subdirectories to make sure postgres user has access to those<br /> :sudo chown -R &lt;ownername&gt;:&lt;groupname&gt; &lt;foldername&gt;<br /> 5. Restart PostgreSQL<br /> :/usr/&lt;postgres folder&gt;/bin/pg_ctl start -D &lt;new path&gt;<br /> :/usr/&lt;postgres folder&gt;/bin/pg_ctl status -D &lt;new path&gt;</div>

Ktnguyen17