On 06/22/2012 03:19 PM, Stefan Schwarzer wrote:
sudo su - _postgres /usr/local/pgsql-9.1/bin/initdb -U postgres -D
/usr/local/pgsql-9.1/data --encoding=UTF8 --locale=en_US
sudo su - _postgres /usr/local/pgsql-9.1/bin/pg_ctl start -D
/usr/local/pgsql-9.1/data
Although I don't get an error
I am following the instructions on the wiki
https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#PITR.2C_Warm_Standby.2C_Hot_Standby.2C_and_Streaming_Replication
using the 10 minute version of the setup.
On the master I have
postgresql.conf
wal_level = hot_standby
max_wal_senders = 3
On 06/23/2012 02:33 PM, Robert Poor wrote:
[std_disclaimer]I'm not a DBA and I'm running PostgreSQL on a
quad-core Intel laptop. You may read on after you stop
laughing...[/std_disclaimer]
Laughing?
You don't need to be a formally-qualified DBA to use Pg. That's half the
point - it's
Craig:
On Sun, Jun 24, 2012 at 12:06 AM, Craig Ringer ring...@ringerc.id.au wrote:
That [implementation of UPSERT] is incorrect; it's subject to several nasty
races.
The best article I've seen on this is here:
http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
You're right --
On 06/24/2012 03:42 PM, Robert Poor wrote:
Craig:
On Sun, Jun 24, 2012 at 12:06 AM, Craig Ringer ring...@ringerc.id.au wrote:
That [implementation of UPSERT] is incorrect; it's subject to several nasty
races.
The best article I've seen on this is here:
On Sat, 2012-06-23 at 12:18 +, Jasen Betts wrote:
On 2012-06-19, Rafal Pietrak ra...@zorro.isa-geek.com wrote:
And we are talking about interractive psql breaking transaction because
of syntax error - almost always this is a one time typo. I'd prefere it
to be a bit more sloopy, then
On Sun, Jun 24, 2012 at 1:57 AM, Tim Uckun timuc...@gmail.com wrote:
I am following the instructions on the wiki
https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#PITR.2C_Warm_Standby.2C_Hot_Standby.2C_and_Streaming_Replication
using the 10 minute version of the setup.
What
Hi!
I've tried (a lot, let me say) to compile ODBC FDW in Win32 and Win64
platforms, without success at all.
Compilers tried so far:
MinGW Gcc
Win32 port of Gcc
Microsoft Visual C++ 2005 32 and 64 bits
None of them had success, with lots of all sort of errors...
I'm afraid I'm not a C coder
On Sun, Jun 24, 2012 at 1:37 PM, Rafal Pietrak ra...@zorro.isa-geek.comwrote:
On Sat, 2012-06-23 at 12:18 +, Jasen Betts wrote:
On 2012-06-19, Rafal Pietrak ra...@zorro.isa-geek.com wrote:
And we are talking about interractive psql breaking transaction because
of syntax error -
Hi,
I have been making some test with EXISTS and I found I case that I do not
understand too well:
CREATE TABLE testing (
number_id serial,
number1 integer,
number2 integer
);
INSERT INTO testing (number1, number2) VALUES (1,1),(1,2),(2,3);
SELECT *
FROM testing
WHERE EXISTS (SELECT 1 FROM
On Jun 24, 2012, at 22:19, Excite Holidays ehte...@gmail.com wrote:
Hi,
I have been making some test with EXISTS and I found I case that I do not
understand too well:
CREATE TABLE testing (
number_id serial,
number1 integer,
number2 integer
);
INSERT INTO testing (number1, number2)
I am using 9.1.
Apparently it's working now, it took a couple of restarts but it seems
to be going.
Thanks.
On Mon, Jun 25, 2012 at 12:57 PM, Michael Nolan htf...@gmail.com wrote:
On Sun, Jun 24, 2012 at 1:57 AM, Tim Uckun timuc...@gmail.com wrote:
I am following the instructions on the
We have an old postgres installation (8.3) running on windows 2003
The server run perfect for many years but today it crash L
We have a very old backup so I'll try desperate to repair.
If I can't repair I want to skip the error and start server with only
healthy data, no matter if I lose
That makes sense. Thanks!
On Mon, Jun 25, 2012 at 12:52 PM, David Johnston pol...@yahoo.com wrote:
On Jun 24, 2012, at 22:19, Excite Holidays ehte...@gmail.com wrote:
Hi,
I have been making some test with EXISTS and I found I case that I do
not understand too well:
CREATE TABLE
El 24/06/2012 09:53 p.m., Anibal David Acosta escribió:
We have an old postgres installation (8.3) running on windows 2003
The server run perfect for many years but today it crash L
We have a very old backup so I'll try desperate to repair.
If I can't repair I want to skip the error and
On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta a...@devshock.comwrote:
We have an old postgres installation (8.3) running on windows 2003
The server run perfect for many years but today it crash L
** **
We have a very old backup so I’ll try desperate to repair.
If I
El 24/06/2012 11:30 p.m., René Romero Benavides escribió:
El 24/06/2012 09:53 p.m., Anibal David Acosta escribió:
We have an old postgres installation (8.3) running on windows 2003
The server run perfect for many years but today it crash L
We have a very old backup so I'll try desperate to
Yes, we must upgrade.
The value of the shared_preload_libraries is
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'
# (change requires restart)
An additional information..
When I login into the server the disk used by Postgres installation was
without space (0Bytes
On Mon, Jun 25, 2012 at 10:10 AM, Anibal David Acosta a...@devshock.comwrote:
Yes, we must upgrade.
The value of the shared_preload_libraries is
** **
shared_preload_libraries =
'$libdir/plugins/plugin_debugger.dll' #
(change requires restart)
On 06/25/2012 12:40 PM, Anibal David Acosta wrote:
Yes, we must upgrade.
The value of the shared_preload_libraries is
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' #
(change requires restart)
Change that to:
shared_preload_libraries = ''
(two single quotes, not a
Hi there,
I am pg_dump-ing all tables from schema public on the server
/usr/local/pgsql/bin/pg_dump -U user my_database --schema=public
--encoding=UTF-8 dump.sql
and re-loading it via psql on my local machine.
But instead of having 708 tables as on the server, I end up with
21 matches
Mail list logo