COPY (SELECT * FROM page WHERE "PublishDate" between '2014-03-01' and
'2014-04-01') TO
'/home/ygg/sql/backup/pagedump.2014-03-01.to.2014-04-01.copy';
gives me:
ERROR: could not open file
"/home/ygg/sql/backup/pagedump.2014-03-01.to.2014-04-01.copy" for
writing: No such file or directory
Running
On 05/23/2014 08:57 AM, Vincent de Phily wrote:
> I need to reduce downtime to a minimum, so I can't afford to let "alter table
> set tablespace" take an exclusive lock on the table for the 2h it'll take to
> copy the data.
You might look at pg_repack (https://github.com/reorg/pg_repack). The
m
Vincent de Phily writes:
> Hi list,
>
>
> I'm in the process of moving some tables to a new tablespace ahead of disk
> space issues. I'm on PG 9.1, using streaming replication.
>
> I need to reduce downtime to a minimum, so I can't afford to let "alter table
> set tablespace" take an exclusive
basti writes:
> Hello,
> I'm running a barman test system.
> Last night there was a Hardware failure.
> my postgres.conf looks like
>
> root@srv-007:/var/log/postgresql# cat
> /etc/postgresql/9.3/barman_recover/postgresql.conf | egrep -v "(^#|^$|^;)"
> data_directory = '/var/lib/postgresql/9.3/ba
Considering submitting a Postgres Open proposal? Let's have a
brainstorming session where we can fish for ideas, talk them over, and
generally get ready to propose a talk!
Postgres Open CFP: http://postgresopen.org/2014/callforpapers/
Inspired by PyLadies' PyCon Proposal Brainstorm Sessions:
htt
Hi list,
I'm in the process of moving some tables to a new tablespace ahead of disk
space issues. I'm on PG 9.1, using streaming replication.
I need to reduce downtime to a minimum, so I can't afford to let "alter table
set tablespace" take an exclusive lock on the table for the 2h it'll take
Victor Sterpu wrote:
> When I run the query from down I receive an error.
> How can I write this query to receive the day ot the week.
> SELECT EXTRACT(DOW FROM timestamp TO_TIMESTAMP('14-10-2011', 'DD-MM-'));
Maybe you mean
SELECT EXTRACT(DOW FROM TO_TIMESTAMP('14-10-2011', 'DD-MM-'));
Hello
When I run the query from down I receive an error.
How can I write this query to receive the day ot the week.
SELECT EXTRACT(DOW FROM timestamp TO_TIMESTAMP('14-10-2011',
'DD-MM-'));
Thank you
Hello,
I'm running a barman test system.
Last night there was a Hardware failure.
my postgres.conf looks like
root@srv-007:/var/log/postgresql# cat
/etc/postgresql/9.3/barman_recover/postgresql.conf | egrep -v "(^#|^$|^;)"
data_directory = '/var/lib/postgresql/9.3/barman_recover' # use data in
ano
