Search Postgresql Archives

Re: Major upgrade of PostgreSQL and MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sat, Sep 14, 2013 at 01:54:40AM +0800, Patrick Dung wrote:
> 1. In the past, I have an impression that it requires double of the database
> size.
> Because the manual present in a way that it 'must' need to hold the old and new
> database cluster.
> But it does not mention the benefit of using hard links to save disk space and
> speed.
> I think the documentation could put a note at the beginning for new users.
> 
> 2. Also I think the documentation should provide more info for users that use
> packages.
> Most likely the system would do dependency checking and may refuse two install
> two versions at the same time.
> So uses need to install the new version in another location.
> More documentation should be provided for this part (e.g for users using Linux
> rpm/deb or FreeBSD ports).
> 
> 3. But the way, if users is using Windows, is the link option still works?

I have applied the attached documentation addition to mention that link
mode uses less disk space, and that junction points are used on Windows.
Backpatched to 9.3.

-- 
  Bruce Momjian  <bruce@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +
diff --git a/doc/src/sgml/pgupgrade.sgml b/doc/src/sgml/pgupgrade.sgml
new file mode 100644
index f6cd9f0..27d41ff
*** a/doc/src/sgml/pgupgrade.sgml
--- b/doc/src/sgml/pgupgrade.sgml
***************
*** 122,128 ****
       <varlistentry>
        <term><option>-k</option></term>
        <term><option>--link</option></term>
!       <listitem><para>use hard links instead of copying files to the new cluster</para></listitem>
       </varlistentry>
  
       <varlistentry>
--- 122,129 ----
       <varlistentry>
        <term><option>-k</option></term>
        <term><option>--link</option></term>
!       <listitem><para>use hard links instead of copying files to the new
!       cluster (use junction points on Windows)</para></listitem>
       </varlistentry>
  
       <varlistentry>
*************** NET STOP pgsql-8.3  (<productname>Postgr
*** 333,339 ****
  
      <para>
       If you use link mode, the upgrade will be much faster (no file
!      copying), but you will not be able to access your old cluster
       once you start the new cluster after the upgrade.  Link mode also
       requires that the old and new cluster data directories be in the
       same file system.  (Tablespaces and <filename>pg_xlog</> can be on
--- 334,341 ----
  
      <para>
       If you use link mode, the upgrade will be much faster (no file
!      copying) and use less disk space, but you will not be able to access
!      your old cluster
       once you start the new cluster after the upgrade.  Link mode also
       requires that the old and new cluster data directories be in the
       same file system.  (Tablespaces and <filename>pg_xlog</> can be on
-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux