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 focused
Craig:
On Sun, Jun 24, 2012 at 12:06 AM, Craig Ringer 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 -- that's a thorough
On 06/24/2012 03:42 PM, Robert Poor wrote:
Craig:
On Sun, Jun 24, 2012 at 12:06 AM, Craig Ringer 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-complicat
On Sat, 2012-06-23 at 12:18 +, Jasen Betts wrote:
> On 2012-06-19, Rafal Pietrak 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 deployed SQL ap
On Sun, Jun 24, 2012 at 1:57 AM, Tim Uckun 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 version of postg
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 wrote:
> On Sat, 2012-06-23 at 12:18 +, Jasen Betts wrote:
> > On 2012-06-19, Rafal Pietrak wrote:
> >
> > > And we are talking about interractive psql breaking transaction because
> > > of syntax error - almost always this is a one time typo. I'
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 testi
On Jun 24, 2012, at 22:19, Excite Holidays 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) VALUES
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 wrote:
>
>
> On Sun, Jun 24, 2012 at 1:57 AM, Tim Uckun wrote:
>>
>> I am following the instructions on the wiki
>>
>> https://wiki.postgr
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 som
That makes sense. Thanks!
On Mon, Jun 25, 2012 at 12:52 PM, David Johnston wrote:
> On Jun 24, 2012, at 22:19, Excite Holidays 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 s
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 start
On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta wrote:
> 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 repai
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 re
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 availab
On Mon, Jun 25, 2012 at 10:10 AM, 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)
>
> **
>
F
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 doubl
>> 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 ser
Out of curiosity, what happens if you dump that database without specifying
a schema - do you get all 708 tables?
On Fri, Jun 22, 2012 at 8:45 PM, Stefan Schwarzer wrote:
> Hi there,
>
> I am pg_dump-ing all tables from schema public on the server
>
> /usr/local/pgsql/bin/pg_dump -U user m
I'd also wonder if it shows up when he does -N public (exclude public schema)?
On Mon, Jun 25, 2012 at 12:37 AM, Anthony Bull wrote:
> Out of curiosity, what happens if you dump that database without specifying
> a schema - do you get all 708 tables?
>
>
> On Fri, Jun 22, 2012 at 8:45 PM, Stefan
>>> 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 message, I don't have the feeli
22 matches
Mail list logo
