Re: question - Mailing list pgsql-general

From Adrian Klaver
Subject Re: question
Date
Msg-id 562ABCBA.3000508@aklaver.com
Whole thread Raw
In response to question  (anj patnaik <patna73@gmail.com>)
List pgsql-general
On 10/23/2015 03:22 PM, anj patnaik wrote:
> Quick update on the above:
>
> 1) I got past the password prompt by changing the pg_hba.conf on target
> machine to trust.
>
> 2) I am still running this command to restore on remote machine and want
> feedback as it appears to NOT create the desired table:
>
> xzcat dump_xz |/opt/PostgreSQL/9.4/bin/psql -h mycomp.com
> <http://mycomp.com> postgres -U postgres

I do not see that working for the reason below:

/pg_dump -t RECORDER  -Fc postgres -Z0 | xz -9 > /tmp/dump_xz

http://www.postgresql.org/docs/9.4/interactive/app-pgdump.html
"
F format
--format=format

     Selects the format of the output. format can be one of the following:

     p
     plain

         Output a plain-text SQL script file (the default).
     c
     custom

         Output a custom-format archive suitable for input into
pg_restore. Together with the directory output format, this is the most
flexible output format in that it allows manual selection and reordering
of archived items during restore. This format is also compressed by
default. "


In particular- 'Output a custom-format archive suitable for input into
pg_restore. '

psql will not know what to do with this.


>
>
> Thanks.
>
>
> On Fri, Oct 23, 2015 at 6:07 PM, anj patnaik <patna73@gmail.com
> <mailto:patna73@gmail.com>> wrote:
>
>     Thanks Adrian. I've got postgres 9.4 running on a second RHEL 6.5
>     machine. This is the machine I want to restore the pg_dump to.
>
>     Last week, I ran this command on the main PG 9.4 db server:
>
>     ./pg_dump -t RECORDER  -Fc postgres -Z0 | xz -9 > /tmp/dump_xz
>
>     The -Z0 turns off compression. So I used xz and noticed the file was
>     not that big.
>
>     Now, I got PG 9.4 running today on a 2nd machine. I just did the
>     initdb, started service, updated the hba.conf and postgres.conf to
>     accept connections from the outside and then restarted service.
>
>     1) When i attempt to restore the archived, I get an error to provide
>     password and I am confused what to do here.
>
>     2) is it correct to do xzcat and then pipe that to pgsl? I want to
>     restore on mymachine.com <http://mymachine.com>
>
>     3) on the target machine, I ran initdb and by default it creates
>     postgres. Will that be a problem when restoring?
>
>     On this machine I am connected as root.
>
>     xzcat dump_xz |/opt/PostgreSQL/9.4/bin/psql -h mymachine.com
>     <http://mymachine.com> postgres
>     Password:
>
>
>     Thank you!
>
>     On Sat, Oct 17, 2015 at 7:42 AM, Francisco Olarte
>     <folarte@peoplecall.com <mailto:folarte@peoplecall.com>> wrote:
>
>         Hi Anj:
>
>         On Sat, Oct 17, 2015 at 3:11 AM, anj patnaik <patna73@gmail.com
>         <mailto:patna73@gmail.com>> wrote:
>         > My question is for Francisco who replied regarding xz. I was curious what
>         > options he used. Thanks.
>
>         1st, we do not normally top post on this list.
>
>         Second, I do not remember the exact options I use. I can look
>         them up,
>         but they are going to be surely useless ( they are for a custom
>         process with does several things with files, it uses gzip ( in Fc
>         backups ), plus xz ( for some files which need to be kept for a long
>         time and are nearly never needed ), plus lzo ( as I found lzo
>         compressed temporary files were faster than uncompressed ones ),
>         and a
>         lot of code. But in the development process we did a full comparison
>         of several compressor, and found what I stated with bzip2, it was
>         surpassed in every combination of options by xz ( plain bzip2, plain
>         xz ).
>
>         Francisco Olarte.
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Fwd: trouble downloading postgres 9.4 for RHEL 6.x
Next
From: Rafal Pietrak
Date:
Subject: partial JOIN (was: ID column naming convention)