Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #760

Re: Issues with backing up Postgres by copying folder

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!post02.iad.highwinds-media.com!fx17.iad.POSTED!not-for-mail
From DFS <nospam@dfs.com>
Subject Re: Issues with backing up Postgres by copying folder
Newsgroups comp.databases.postgresql
References <smBIA.407$xR7.221@fx28.iad> <20170419201146.02a1844344207bc63a19edcf@shallow.house> <HNzMA.23981$So6.1424@fx17.iad> <20170502000731.7d5f6e4492d851c4800bd500@shallow.house> <tS1OA.59756$So6.15017@fx17.iad> <m2inli1kcr.fsf@dimitris-mbp.home>
X-Mozilla-News-Host news://usnews.blocknews.net
User-Agent Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.1.0
MIME-Version 1.0
In-Reply-To <m2inli1kcr.fsf@dimitris-mbp.home>
Content-Type text/plain; charset=utf-8; format=flowed
Content-Language en-US
Content-Transfer-Encoding 7bit
Lines 23
Message-ID <ZLqOA.1$3S4.0@fx17.iad> (permalink)
X-Complaints-To abuse@blocknews.net
NNTP-Posting-Date Wed, 03 May 2017 20:07:21 UTC
Organization blocknews - www.blocknews.net
Date Wed, 3 May 2017 16:07:26 -0400
X-Received-Bytes 1825
X-Received-Body-CRC 2887064900
Xref csiph.com comp.databases.postgresql:760

Show key headers only | View raw

On 5/3/2017 3:16 AM, Dimitri Fontaine wrote:
> DFS <nospam@dfs.com> writes:
>> Shocking eh?  But it's been robust and is still speedy for SELECTs. Adding
>> indexes and doing some other table operations now takes 20 minutes on the
>> big table.  So I'm gonna upgrade to Postgres.
> 
> pgloader can migrate the schema and data over in a single command, so I
> think you should have a look in case that's useful to you:
> 
>    http://pgloader.io
>    pgloader ./test/sqlite/sqlite.db postgresql://user@host/newdb
> 
> Regards,


I'll look into that one, thanks.

To learn Postgres I've been building and loading one table at a time.

'SERIAL' was new to me.
the COPY utility was handy for populating tables
psql is really powerful
pgAdmin4 v1.3 is /ridiculously/ slow on Windows

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-15 23:17 -0400
  Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-04-19 20:11 +0100
    Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 00:45 -0400
      Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-02 00:07 +0100
        Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-02 11:48 -0400
          Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-03 09:16 +0200
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-03 16:07 -0400
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-20 20:01 -0400
              Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-21 13:46 +0200
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-21 08:48 -0400
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-31 07:29 -0400
                Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-31 14:26 +0200
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-31 09:52 -0400
                Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-31 16:27 +0200
          Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-03 13:57 +0100
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-11 11:11 -0400
              Re: Issues with backing up Postgres by copying folder Robert Klemme <shortcutter@googlemail.com> - 2017-05-11 23:08 +0200
    Re: Issues with backing up Postgres by copying folder Gordon Gekko <greed@is.good.invalid> - 2017-05-08 02:39 +0000
  Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-23 22:15 +0100
    Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 00:42 -0400
      Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 12:39 +0100
        Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 11:16 -0400
          Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 16:42 +0100
            Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 16:48 +0100
              Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-02 00:00 +0100
              Re: Issues with backing up Postgres by copying folder Mladen Gogala <gogala.mladen@gmail.com> - 2017-05-08 02:41 +0000

csiph-web