Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOiiK-008Grn-O7 for pgsql-es-ayuda@arkaria.postgresql.org; Fri, 20 Dec 2024 19:31:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tOiiJ-00FjB1-6B for pgsql-es-ayuda@arkaria.postgresql.org; Fri, 20 Dec 2024 19:31:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOiiI-00FjAp-U3 for pgsql-es-ayuda@lists.postgresql.org; Fri, 20 Dec 2024 19:31:06 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tOiiF-000bSZ-Vk for pgsql-es-ayuda@postgresql.org; Fri, 20 Dec 2024 19:31:05 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-6efe4324f96so19673397b3.1 for ; Fri, 20 Dec 2024 11:31:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734723063; x=1735327863; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id:from :to:cc:subject:date:message-id:reply-to; bh=vx2TKD6hugIYC56OicD6DnGYxHNXipnDLhNieF5dxgs=; b=f/Dc9mqqSrjlw6l6MOUZJ9bnmcDDoFIU1lKytaAWfs+Xm7OheGPkn1BtvbRNgqZvtR 2QK9rKucWoGWeRjIoCSgqKmUZv4iUyM0LJEThtzV7XNwMZ8FoGcrpd6YP1fMpQ+gg4Oq jg2Q8hn9g9Bp2qS0Vj12SfrJD6DyPD8NBqW6WZXa0cL/osKcrZIMPHMDjhjc+ItNhWx3 sHbmGJ/EC1rd544PZFgBYrD/f25jl6nlkcKmRTJuQL5VNZIzG9S9xFbpKWkSk/QN8vDO 3g9dwaE+B3OyBADcwFnd0z/A14X60QjJFdgdsuAPiyf3BpKrvObJbm7aRr9qf9vuMMnz 378g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734723063; x=1735327863; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=vx2TKD6hugIYC56OicD6DnGYxHNXipnDLhNieF5dxgs=; b=qQxnfdZQyFSJ4IlnY2zP0PBCDWYd2wjnc6vQB5wJvGkRD+gh5VA2v97GnpwUfQkwKO SGK7Ng0oua1auLnazHALpPeHXXcvXwS5AxG7mpmUE6yt2OH+C7XohEc/EukmTo2fjci7 bAVEVp8wWPAHl9DGFG8b/kvsQQjLjpmP2k16pcd87f3wFWVNbIqjEItP9fauFKYyiVfP UTS+VbCuaHIdWXeSu3eOaD+gKkGfrRv9I6vnJjjdqb97BHCSceTQ1LIz734gGU3zR0Jd JdAl4WZFnY7fon6yYJNIYpawFhV7VGY6jvxov0+dPlcmWbGCHKOwh7C9qoEPcmxPHb6r Si4Q== X-Forwarded-Encrypted: i=1; AJvYcCUzzpahuZd27PvVULzxWZ49qVpK+nYc96ZwWgSJBHskWXKTV2ufSp5yyzySyEsz28tT5va5m0bS7qr5jR1i9A==@postgresql.org X-Gm-Message-State: AOJu0YzYy83SHzaTG8z3qk5HjNIxBCdKCFXu57v16h91or8P8K2ytW5H /TeUgbqynklOHToQrLkE9qIqt5/HP8Q5ttUKeQXcxbx8KGa8N+6C X-Gm-Gg: ASbGncv7ll0vAJe5RCMY/YBlV181NelbK3ZTPV0511YVlL8LdgR1y3gsek6MDrCCkjR akEpFExMmehOd2iV/o4VoP2XUO/AvxeQ0ol+2yHViMvjjU2azX/LsIz1xLqNaG0S64G/+gy4bRw YMhB6MLYepMaA8YSyW/4Bqi73pbVBv7XQcF+Npr3xNJjcMAxCgVwrGQiOQZI/OZ+0R8jiiJi4Mm pmlghST75N19iRigcENtQSqsd1dJXTU3lLtjxa0cdXDiRBz0nqjB6KQi5z9+ktj X-Google-Smtp-Source: AGHT+IGyhOk3Asj8KrWuIdHCwhXJDGyLdODUEIQkVlemx7gSljRR8VPiclyY86rEw0KDpi4h64tHng== X-Received: by 2002:a05:690c:fc5:b0:6ef:a6be:7c31 with SMTP id 00721157ae682-6f3f80e5246mr42218737b3.2.1734723062837; Fri, 20 Dec 2024 11:31:02 -0800 (PST) Received: from [192.168.1.103] ([152.206.141.112]) by smtp.gmail.com with ESMTPSA id 00721157ae682-6f3e74997f3sm9544757b3.69.2024.12.20.11.31.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Dec 2024 11:31:02 -0800 (PST) Message-ID: Date: Fri, 20 Dec 2024 16:30:59 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_dumpall o pg_dump sin funciones To: kernel , Ayuda References: Content-Language: en-US From: Anthony Sotolongo In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hola, si estas usando la version 17, creo que agregaron algo en el pg_dump/pg_restore para eso, un parametro llamado --filter https://www.postgresql.org/docs/17/app-pgdump.html https://www.postgresql.org/docs/17/app-pgrestore.html de lo contrario puede que tengas que jugar con los parametris -l y -L de pg_restore si vas a restaurar Saludos On 20-12-24 06:53, kernel wrote: > Hola, > > No se si es posible ; me gustaría sacar una copia de la base de datos > que no incluya ninguna de las funciones de plpsql que tengo > desarrolladas, todas tienen un mismo patron , todas empiezan igual > > Gracias > > > >