Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gojK0-0003Pl-MM for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 06:26:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gojJz-0008Li-0E for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 06:26:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gojJy-0008Lb-Lk for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 06:26:02 +0000 Received: from mail-oi1-x243.google.com ([2607:f8b0:4864:20::243]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gojJr-0003b4-R0 for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 06:26:02 +0000 Received: by mail-oi1-x243.google.com with SMTP id x23so18333859oix.3 for ; Tue, 29 Jan 2019 22:25:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=dRoS3ldacgDS+3ZqUY6U+fUgqgdk0JqmMF0MvHnAkRM=; b=DsOsFNE+10//jTxHYTSnovbjAemDVrMrzncdPanEdmxPmatVEB8erKC+YD84BaqYpx lacumv9gvstzxBOr0I1FngjGZGtvCz+VGil6PyboK68Uh9tQkWxSs2RFsz+W5WECKwWZ YR0aSfqvlPivw9e/dR/nKaJXMbABHiHdAx5vH7Uyfyrv/YYBnVNMY1a6pBzsgA/QO98N iWnk8doiUo2hvaIggrQTszhdkmOm/GhF1O77uKFr0POY2NdR+WuTw8pplDN/pn8PbXPS VVq46irERjsaWSpXH5sz0gte2HM8yiZMW7KcxwJid3d4nWlTaVp1nxzQLoKGt1IRADSd R0MA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=dRoS3ldacgDS+3ZqUY6U+fUgqgdk0JqmMF0MvHnAkRM=; b=OYUKtvwPOTFWChcKqXtACgKNLc9rPwqFlLCNpTHpGv/DnwIxeS6DU49VhMag727mv3 iAxVIsNSQh0Y+a5BueNO8yEB43YQHs0quhe1GR66dQZdyRNSC2tYgzQMNn1Lo+WRvszg KkqM14i18yTTfGzxAa4z6sQ0cP1OsjDIlcNsm97YmIyBQmCUxQaOIdELVGxntV97HTf/ Im+Ry4Xh40xt80VWqjJI78a3nhL+aEM9MQsChZmTp17ePwJaGBlj0g7Jr73Wh5vyMW8M gLLFZwsUO/3m9lGo96XH+q6ZsY6ECOVQJQVecT0VpTHSc6d5LpVlh58u6ABODn6MNpKx 0IXg== X-Gm-Message-State: AHQUAuacqyVH5ct7cKBylb+wQedwiveA4PJmoWDWIznDlL9p5l5HM79y ep1R2RwMwrLub3haQuA4R8yi3Uzg X-Google-Smtp-Source: ALg8bN4rkNZrF0x6wE/M+8iGcRTBYLsMlhjVtGSBcLhk0gzJYBVXhlGT2ntT3BJznYYFMRsVBaWoiA== X-Received: by 2002:aca:4208:: with SMTP id p8mr11969570oia.331.1548829553718; Tue, 29 Jan 2019 22:25:53 -0800 (PST) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id d5sm246412oth.78.2019.01.29.22.25.52 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 29 Jan 2019 22:25:52 -0800 (PST) Subject: Re: Postgres Complete backup To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <2eb9f619-a9a5-5862-b8ce-1fdead69378a@gmail.com> Date: Wed, 30 Jan 2019 00:25:52 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/30/19 12:19 AM, Sridhara KB wrote: > Hi, > > How can i take postgres complete backup including users schema triggers etc….. > > P.S currently running postgres 9.4 https://www.postgresql.org/docs/9.6/app-pgdump.html -- Angular momentum makes the world go 'round.