Hi David,
Here is another approach. See if it serves your purpose
postgres=# create schema idev;
CREATE SCHEMA
postgres=#
postgres=#
postgres=# CREATE TABLE idev.assessment_result_2023_dab (
district_oid int,
-- other columns go here
column1 numeric,
column2 numeric
);
CREATE TAB
On Thursday, June 6, 2024, Kashif Zeeshan wrote:
> Hi
>
> On Fri, Jun 7, 2024 at 6:54 AM Ron Johnson
> wrote:
>
>>
>> https://www.postgresql.org/docs/14/app-pgbasebackup.html doesn't mention
>> "--compress=[{client|server}-]method". That first appears in the v15
>> docs.
>>
>> And yet pg_baseba
Hi
On Fri, Jun 7, 2024 at 6:54 AM Ron Johnson wrote:
>
> https://www.postgresql.org/docs/14/app-pgbasebackup.html doesn't mention
> "--compress=[{client|server}-]method". That first appears in the v15 docs.
>
> And yet pg_basebackup doesn't complain about an invalid option.
> (Technically, this
On Fri, Jun 7, 2024 at 3:19 AM Koen De Groote wrote:
> I'll give them a read, though it might take a few weekends
>
> Meanwhile, this seems to be what I'm looking for:
>
> From
> https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS
>
> " Replication slots provide
https://www.postgresql.org/docs/14/app-pgbasebackup.html doesn't mention
"--compress=[{client|server}-]method". That first appears in the v15 docs.
And yet pg_basebackup doesn't complain about an invalid option.
(Technically, this is a bug; I first noticed it a week after copying a
script from a
I'll give them a read, though it might take a few weekends
Meanwhile, this seems to be what I'm looking for:
From
https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS
" Replication slots provide an automated way to ensure that the primary
does not remove WAL segm
On 6/6/24 10:37, Marcelo Marloch wrote:
Reply to list also.
Ccing list
Hi Adrian thanks for your help, Server is running on windows and I set
open 5432 port on windows firewall, I did not see any options regarding
if ipv4 or v6. client also uses windows and connects through odbc
driver. over
On Thu, 2024-06-06 at 11:46 -0300, Marcelo Marloch wrote:
> Hi everyone, is it possible to remote connect through IpV6? IpV4
> works fine but I cant connect through V6
>
> postgresql.conf is to listen all address and pg_hba.conf is set
> with host all all :: md5 i've tried ::/0 and ::0/0 but had
## David Barbour (dbarb...@istation.com):
> Now I need to 'attach' the original table. The problem I'm running into is
> there are no good examples of how to define the values.
The syntax is the same as with CREATE TABLE ... PARTITION OF, e.g.
ALTER TABLE parent ATTACH TABLE part FOR VALUES WITH
Hi all,
I'm using logical replication with Postgres 15.2.
When creating logical replication on multiple tables, sometimes the initial
sync get stuck for few tables at state srsubstate = f. If I recreate the
logical replication again, it may get stuck at srsubstate = f for other
tables, so it
Hi,
New to this list and to Postgres. Been an Oracle DBA for quite a while and
we're moving from Oracle to Postgres.
I have a table that I need to transform into a hash partitioned table.
I've gone through all the steps to create a hash partitioned table, with 8
partitions such as
create table
On Wed, Jun 5, 2024 at 6:26 AM Laurenz Albe
wrote:
> On Wed, 2024-06-05 at 06:36 +, Meera Nair wrote:
> > 2024-06-05 11:41:32.369 IST [54369] LOG: restored log file
> "00050001006A" from archive
> > 2024-06-05 11:41:33.112 IST [54369] LOG: restored log file
> "0005000100
On Thu, Jun 6, 2024 at 11:03 AM Adrian Klaver
wrote:
> On 6/6/24 07:46, Marcelo Marloch wrote:
> > Hi everyone, is it possible to remote connect through IpV6? IpV4 works
> > fine but I cant connect through V6
> >
> > postgresql.conf is to listen all address and pg_hba.conf is set with
> > host al
On 6/6/24 07:46, Marcelo Marloch wrote:
Hi everyone, is it possible to remote connect through IpV6? IpV4 works
fine but I cant connect through V6
postgresql.conf is to listen all address and pg_hba.conf is set with
host all all :: md5 i've tried ::/0 and ::0/0 but had no success
Is the firew
Hi Marcelo
Yes it's possible to connect remotely with postgres with ipv6 e.g. with
psql.
If you are facing issues then you need to make sure that you have done the
required configurations.
Please refer to the following links for more details.
https://dba.stackexchange.com/questions/148086/how-do
Hi everyone, is it possible to remote connect through IpV6? IpV4 works fine
but I cant connect through V6
postgresql.conf is to listen all address and pg_hba.conf is set with host
all all :: md5 i've tried ::/0 and ::0/0 but had no success
my provider is out of ipv4 and they're sending ips by cgn
On Wed, 2024-06-05 at 16:24 -0400, bruno vieira da silva wrote:
> Hello, if a pg version has been tested on the buildfarm but the pg yum
> repository doesn't have packages for a linux distribution that means
> that distribution isn't supported by pg? how can I find if linux
> distributions for a pg
17 matches
Mail list logo
