Do you use archive_command or pg_receivexlog to archive your WAL files?
If you use archive_command, then, as Jarry has already stated, you
will have *.backup files in your WAL archive, the latest of which
points to the beginning of the WAL files set needed for the latest
base backup.
If you use p
Virupaksha Kanjilal writes:
> Hi
>
> I perform a pg_basebackup with tar option and do not bring in the WAL
> segments created during the backup. Now I want
> to make the backup a consistent copy and for that I need the WAL segments.
> How can I know which all WAL segments to
> apply to bring th
k...@rice.edu wrote:
> Each SELECT opens your FOREIGN TABLE so you are opening it 10 times. This is
> hardcoded by a #define in ./src/backend/storage/file/fd.c during the build so
> you would need to recompile the software yourself to change it. Can you re-
> write your query using a single SELECT
The csv has 34 columns and I need to create a crosstab (using 8 columns so
I can't use built in crosstab functions). That is why I need to make
several sql select.
I'm using foreign table so my client can update is csv file without having
to run the ETL to update a table in postgres.
Using tem
>
> Hi Steve,
>
> Each SELECT opens your FOREIGN TABLE so you are opening it 10 times.
> This is hardcoded by a #define in ./src/backend/storage/file/fd.c
> during the build so you would need to recompile the software yourself
> to change it. Can you re- write your query using a single SELECT or
On Tue, May 28, 2013 at 11:28:02AM -0400, steve.tout...@inspq.qc.ca wrote:
> Hi,
> Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
> But I need to change the structure of the data and I created several sql
> select using union, like
> select from .foreign table... where
Hi,
Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
But I need to change the structure of the data and I created several sql
select using union, like
select from .foreign table... where...
union
select from .foreign table... where...
union
...
It works for the firs
