mcarman
/
resequenced_pgsql


			
				
					
						
						
							
							<!DOCTYPE html><html><head><meta charset="utf-8"><title>DBResequencer.md</title><style></style></head><body id="preview">
<h1 class="code-line" data-line-start="0" data-line-end="1"><a id="Postgres_Database_ID_Resequencer_0"></a>Postgres Database ID Resequencer</h1>
<p class="has-line-data" data-line-start="3" data-line-end="4">resequence_pgsql is a command line utility to resequence ID’s from the last id entered so you are not violating primary key constraints in the database after initial seed data or migrated data is inserted into the database. This is for Postgres only through an ssh connection.</p>
<h2 class="code-line" data-line-start="5" data-line-end="6"><a id="Installation_5"></a>Installation</h2>
<p class="has-line-data" data-line-start="7" data-line-end="8">resequence_pgsql requires <a href="https://dotnet.microsoft.com/en-us/download/dotnet/8.0">dotnetcore</a> v8.0+ to run.</p>
<p class="has-line-data" data-line-start="9" data-line-end="10">Download the Project</p>
<pre><code class="has-line-data" data-line-start="12" data-line-end="14" class="language-sh">git <span class="hljs-built_in">clone</span> https://cvs.prelub.com/mcarman/resequenced_pgsql.git
</code></pre>
<p class="has-line-data" data-line-start="15" data-line-end="16">For production environments…</p>
<pre><code class="has-line-data" data-line-start="18" data-line-end="20" class="language-sh">dotnet publish -c Release -r &lt;RID&gt; --output &lt;output directory&gt; resequence_pgsql.sln
</code></pre>
<p class="has-line-data" data-line-start="20" data-line-end="21">List of <a href="https://learn.microsoft.com/en-us/dotnet/core/rid-catalog">RID’s</a> can be found here.</p>
</body></html>