Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jqyua-0001NB-M7 for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2020 13:05:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jqyuZ-0002Cl-FJ for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2020 13:05:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jqyuZ-0002Cd-52 for pgsql-admin@lists.postgresql.org; Thu, 02 Jul 2020 13:05:55 +0000 Received: from mail-ot1-x342.google.com ([2607:f8b0:4864:20::342]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jqyuS-0001mP-OV for pgsql-admin@lists.postgresql.org; Thu, 02 Jul 2020 13:05:54 +0000 Received: by mail-ot1-x342.google.com with SMTP id n24so21831014otr.13 for ; Thu, 02 Jul 2020 06:05:47 -0700 (PDT) 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-language; bh=2NN/3R6bDBv4Pn/evk3NZJgvp65SMwonRV3kCnlEhcE=; b=gXq3JzgmlrYM2p5QFrYmeU/7jukNVGqy5IuzCgy/TfNv20L2psl+DFnSUrkKPQQ9Ri bRJihELErQLdDlFIO5AXsTDu3w7rgHw5oULI3fnSO3exDXIeI1FcLc6azBHCP0AcGHvO rpkRmBDOSMZimnwofWXJ49Nx5IjD1XU+0zSOm4dx5qkOww2XL6YHnrgKBAe+pFTGRgG7 JwWQL5nlk+/F8UfwvfWhJRMIdUH59JIKeKp7KMm7NNtK1U+i7NUvp+9cfRrEWBY3IO5D 7Elgr4rLg/F2a9nHVnM9P3ZDIvjHFk8LRU910VP7ybqcqtzWx0972nO4/dPVEJpUa1bT 2eDQ== 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-language; bh=2NN/3R6bDBv4Pn/evk3NZJgvp65SMwonRV3kCnlEhcE=; b=Fb/CER+bFXbBz5K761i0691EA1XWL7Yq5MgKlr4cAhg3ps4NaAghms3oLR0f6ioNmn rR4vqRqvUemzUeJYvw3g9eCFDeUnYMu/PjrVlguz/ByH4EvB8pRstk0o1JugWYOPgY14 JNMgJ2MEXFx+oWRl2Nyt5ZNUILRTjsxAX9189WE3lZLMTtEbOZMnUe1rM8sRyNK0dBF/ uHVwpJZrrCNxYykCde41j+2PS1MB+YdmcJMJnr9zg58sWRt1dmjSxencr/gSf1qilhBh aH04rVpMSQhjb33CBJpVRY1JE1IwsYyouuT/rIUU2H2gbf7n/7tE5Um3J9ethOfBx6gD pdNQ== X-Gm-Message-State: AOAM531cLxytlmDGKuFz7gUql6uK49vR1JvcrIwC3TbQiRG0P7hZdzle i1OgEFcvjPBQ4Ixw9pBXLd/Gz7AbscjUPA== X-Google-Smtp-Source: ABdhPJyapIo0+SHeTx+aa8hQ+G4HRu0nenxgsZsDgm+g3dUei/ioyQXKdP/pYypxueZD5vY9VkSjGg== X-Received: by 2002:a9d:22aa:: with SMTP id y39mr28085908ota.153.1593695145790; Thu, 02 Jul 2020 06:05:45 -0700 (PDT) Received: from [192.168.1.10] (ip70-186-126-197.no.no.cox.net. [70.186.126.197]) by smtp.googlemail.com with ESMTPSA id p1sm2695484oot.34.2020.07.02.06.05.44 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Jul 2020 06:05:45 -0700 (PDT) Subject: Re: move postgrest installation To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <6b259199-333a-3eb0-90f9-1c3c9364f60b@gmail.com> Date: Thu, 2 Jul 2020 08:05:43 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------C869B758A1CA542BE0379F60" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------C869B758A1CA542BE0379F60 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit PostgreSQL is a set of *programs* which get installed.  The databases are created and then populated with your data. Are you really asking about how to move the databases?  If so, then (first shut down postgres, of course), copy the files in /var/lib/pgsql/data to /datos/postgres and then update postgresql.conf, and whatever startup file defines PGDATA. On 7/2/20 6:40 AM, CRISTINA ASENJO CUELLAR wrote: > > Hello all, > > First of all, Thanks you to community, help me with another questions before. > > I have installed postgresql:10 on redhat 8 in this path > (/var/lib/pgsql/data) default installation path, mounted on /var. > > I need to change the location due to storage issues to another FS > (/datos/postgres), how i can do it? > > Or it’s more save to install again (creating a FS mount on > /var/lib/pgsql/data) > > I configured a replica with Wall streaming, How do this change of path >  affect the replica? > -- Angular momentum makes the world go 'round. --------------C869B758A1CA542BE0379F60 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit PostgreSQL is a set of programs which get installed.  The databases are created and then populated with your data.

Are you really asking about how to move the databases?  If so, then (first shut down postgres, of course), copy the files in /var/lib/pgsql/data to /datos/postgres and then update postgresql.conf, and whatever startup file defines PGDATA.


On 7/2/20 6:40 AM, CRISTINA ASENJO CUELLAR wrote:

Hello all,

 

First of all, Thanks you to community, help me with another questions before.

I have installed postgresql:10 on redhat 8 in this path (/var/lib/pgsql/data) default installation path, mounted on /var.

I need to change the location due to storage issues to another FS (/datos/postgres), how i can do it?

Or it’s more save to install again (creating a FS mount on /var/lib/pgsql/data)

I configured a replica with Wall streaming, How do this change of path  affect the replica?


--
Angular momentum makes the world go 'round.
--------------C869B758A1CA542BE0379F60--