Hello, PostGreSQL-Masters
<>
PostGreSQL: 7.4.30 the postgres-installer ( postgresql-7.4.30.tar.gz)
OS: AIXv5.2 TL09 (POWER5)
Machine: 9119-590(1LPAR)
<>
I have got the following status or problem with an initdb command,
which is "initdb -D /usr/local/pgsql/data -d".
The point of "selecting defaul
On 16 Dec 2010, at 18:13, fel...@informidia.com.br wrote:
> Hello,
> I'm having a problem running an update command that invokes a trigger, the
> problem is that the function performed takes about 45 minutes to finish and
> my application is locked waiting for the finish.
> You know how I can'
I'm trying to link up a C++ project with postgres functions, the following code
compiles (as C++):
extern "C" {
#include
#include
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
};
extern "C" {
PG_FUNCTION_INFO_V1(pg_xversion);
};
extern "C" Datu
Hey Elliot,
See http://www.postgresql.org/docs/9.0/static/extend-cpp.html
Probably compiling with -fno-exceptions solve you problem.
2010/12/24 Elliot Chance
> I'm trying to link up a C++ project with postgres functions, the following
> code compiles (as C++):
>
> extern "C" {
>#includ
Cheers! It works.
On 24/12/2010, at 11:13 PM, Dmitriy Igrishin wrote:
> Hey Elliot,
>
> See http://www.postgresql.org/docs/9.0/static/extend-cpp.html
>
> Probably compiling with -fno-exceptions solve you problem.
>
> 2010/12/24 Elliot Chance
> I'm trying to link up a C++ project with postgres
On 12/24/2010 10:29 PM, Elliot Chance wrote:
But the CREATE FUNCTION gives the error:
ERROR: could not load library "/storage/Scripts/pgx/pgx.so":
/storage/Scripts/pgx/pgx.so: undefined symbol: __gxx_personality_v0
How'd you build the C++ code? What was your compile command line? Does
'ldd
On 12/24/2010 11:16 PM, Elliot Chance wrote:
Cheers! It works.
Beware - that's really unsafe if you're calling C++ libraries that may
throw exceptions.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
Hi
I am attempting to restore a database using -
psql PDW < PDW_June_10.sql
psql –U postgres PDW < PDW_June_10.sql
The response asks me for a password.
I use the same password with which I connect to the server but it is not
accepted.
Without the –U postgres identifier it asks me for the pa
I cannot run my accounting software and have, I believe, isolated the
problem by running 'psql' at the command line.
When I run psql logged in as myself I get this error:
[rshep...@salmo ~]$ psql aesi
psql: error while loading shared libraries: libpq.so.5: cannot open shared
object file: Per
On 12/24/10 1:23 PM, Rich Shepard wrote:
I cannot run my accounting software and have, I believe, isolated the
problem by running 'psql' at the command line.
When I run psql logged in as myself I get this error:
[rshep...@salmo ~]$ psql aesi
psql: error while loading shared libraries: libpq
On Fri, 24 Dec 2010, John R Pierce wrote:
wild guess says, libpq.so.5 or whatever its linked to.
John,
That was my original thought, too.
on this system...
$ ls -l /usr/lib/libpq*
lrwxrwxrwx 1 root root 12 Dec 23 2009 /usr/lib/libpq.so.5 ->
libpq.so.5.1
-rwxr-xr-x 1 root root 138
On 12/24/10 1:37 PM, Rich Shepard wrote:
On Fri, 24 Dec 2010, John R Pierce wrote:
wild guess says, libpq.so.5 or whatever its linked to.
John,
That was my original thought, too.
on this system...
$ ls -l /usr/lib/libpq*
lrwxrwxrwx 1 root root 12 Dec 23 2009 /usr/lib/libpq.so.5 ->
On Fri, 24 Dec 2010, John R Pierce wrote:
I'd check the permisisons on /usr/local/pgsql and /usr/local/pgsql/lib too.
if that directory is not o+r, you'll have problems too.
John,
Bingo! The subdirectories in /usr/local/pgsql were 700. Changing them to
755 fixed everything.
_Very_ much
On Fri, 2010-12-24 at 14:09 -0800, Rich Shepard wrote:
> On Fri, 24 Dec 2010, John R Pierce wrote:
>
> > I'd check the permisisons on /usr/local/pgsql and /usr/local/pgsql/lib
> > too.
> > if that directory is not o+r, you'll have problems too.
>
> John,
>
>Bingo! The subdirectories in /u
Hello. Is postgresql able to compress data sent to the client?
--
Sent from my mobile device
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Friday 24 December 2010 12:36:32 pm Bob Pawley wrote:
> Hi
>
> I am attempting to restore a database using -
>
> psql PDW < PDW_June_10.sql
>
> psql –U postgres PDW < PDW_June_10.sql
psql –U postgres -d PDW -f PDW_June_10.sql
>
> The response asks me for a password.
>
> I use the same passwor
On Fri, 24 Dec 2010, Joshua D. Drake wrote:
You will want to make sure you didn't do that to /usr/local/pgsql/data .
/usr/local/pgsql/data should be 700.
Thanks, Josh. Fixed.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
Thanks Adrian but
psql –U postgres -d PDW -f PDW_June_10.sql
asks - "Password for user postgres:"
When I type the password the cursor doesn't respond and on enter I get
password failed.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 2:59 PM
To: pgsql-
On Friday 24 December 2010 3:28:38 pm Bob Pawley wrote:
> Thanks Adrian but
>
> psql –U postgres -d PDW -f PDW_June_10.sql
>
> asks - "Password for user postgres:"
>
> When I type the password the cursor doesn't respond and on enter I get
> password failed.
>
> Bob
>
A little bit of testing on my
On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver wrote:
> On Friday 24 December 2010 3:28:38 pm Bob Pawley wrote:
>> Thanks Adrian but
>>
>> psql –U postgres -d PDW -f PDW_June_10.sql
>>
>> asks - "Password for user postgres:"
>>
>> When I type the password the cursor doesn't respond and on enter I
I have tried this a number of times -
psql –U postgres PDW < PDW_June_10.sql. (with and without spaces between U &
postgres and/or < and PDW_June)
Sometimes I am asked for a postgres password, once I was asked for the PDW
password (this makes sense and which I did enter).
When I entered the
On Friday 24 December 2010 4:03:52 pm Bob Pawley wrote:
> I have tried this a number of times -
> psql –U postgres PDW < PDW_June_10.sql. (with and without spaces between U
> & postgres and/or < and PDW_June)
>
> Sometimes I am asked for a postgres password, once I was asked for the PDW
> password
Version 8.4.1
OS Win 7
I connect through PG Admin (plus an interface I use when the database is up
and running)
The password for this connection is the password I set up during the
installation. this is the same password I am using for the restore
connection.
I haven`t done anything for the po
On Friday 24 December 2010 4:20:13 pm Bob Pawley wrote:
> Version 8.4.1
> OS Win 7
> I connect through PG Admin (plus an interface I use when the database is up
> and running)
> The password for this connection is the password I set up during the
> installation. this is the same password I am using
On Fri, Dec 24, 2010 at 5:03 PM, Bob Pawley wrote:
> I have tried this a number of times -
> psql –U postgres PDW < PDW_June_10.sql. (with and without spaces between U &
> postgres and/or < and PDW_June)
>
> Sometimes I am asked for a postgres password, once I was asked for the PDW
> password (thi
In the windows install PG Admin comes packaged with PostgreSQL.
I`m a little confused. My PDW database has postgres as an owner.
You refer to postgres as a user.
My PG Admin shows postgres as a database along with PDW and
template_postgis.
The postgres database probably has a password.
Mayb
On Fri, Dec 24, 2010 at 6:00 PM, Bob Pawley wrote:
> In the windows install PG Admin comes packaged with PostgreSQL.
>
> I`m a little confused. My PDW database has postgres as an owner.
>
> You refer to postgres as a user.
>
> My PG Admin shows postgres as a database along with PDW and
> template_
On Friday 24 December 2010 5:00:19 pm Bob Pawley wrote:
> In the windows install PG Admin comes packaged with PostgreSQL.
>
> I`m a little confused. My PDW database has postgres as an owner.
>
> You refer to postgres as a user.
The default superuser for Postgres is the user postgres. An owner need
I just stopped the server after changing config to trust and I got the
message `System error 5 has occurred. Access is denied`
Perhaps this is a clue.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 5:15 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org ;
On Fri, Dec 24, 2010 at 6:20 PM, Bob Pawley wrote:
> I just stopped the server after changing config to trust and I got the
> message `System error 5 has occurred. Access is denied`
What exactly did you type. copy and paste, don't transcribe bits and pieces.
--
Sent via pgsql-general mailing l
On Friday 24 December 2010 5:20:50 pm Bob Pawley wrote:
> I just stopped the server after changing config to trust and I got the
> message `System error 5 has occurred. Access is denied`
>
> Perhaps this is a clue.
>
> Bob
>
Does not meaning anything to me. Please lets not push more buttons:)
-
I didn't copy or paste anything. I just clicked Stop.
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 5:41 PM
To: Bob Pawley
Cc: adrian.kla...@gmail.com ; pgsql-general@postgresql.org ; bricklen
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 6:20 PM,
On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawley wrote:
> I didn't copy or paste anything. I just clicked Stop.
No, copy and paste WHAT YOU DID, from your screen into the email. Like this:
smarl...@breckenridge:~$ psql
psql (8.4.5)
Type "help" for help.
smarlowe=# create user joe;
CREATE ROLE
smarl
On Fri, Dec 24, 2010 at 5:03 PM, Bob Pawley wrote:
> I don't know what is meant by your reference to \1.
That's a \l the letter l, not a number. It lists the databases in
your installation. If you can get in by psql then \l should work.
--
Sent via pgsql-general mailing list (pgsql-general@p
On 12/24/10 6:09 PM, Scott Marlowe wrote:
On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawley wrote:
I didn't copy or paste anything. I just clicked Stop.
No, copy and paste WHAT YOU DID, from your screen into the email. Like this:
he's on MS Windows 7. you want him to email screen shots? please,
In a technical discussion, please don't top post. It destroys
formatting of previous comments and disrupts the flow. People trying
to come in halfway down a conversation will be thrown for a loop and
find. I would reformat your reply to be inline but this message isn't
about changing your config
On Fri, Dec 24, 2010 at 7:12 PM, John R Pierce wrote:
> On 12/24/10 6:09 PM, Scott Marlowe wrote:
>>
>> On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawley wrote:
>>>
>>> I didn't copy or paste anything. I just clicked Stop.
>>
>> No, copy and paste WHAT YOU DID, from your screen into the email. Like
>>
When I type psql I am asked for a password. When I attempt to enter a
password the cursor doesn't move.
When I click enter I get failed password for - my computer name.
When I type psql \I - I get the same as above.
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December
On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley wrote:
> When I type psql I am asked for a password. When I attempt to enter a
> password the cursor doesn't move.
It's not supposed to, so don't worry about that.
How exactly are you running psql? Can you show us what you typed in?
> When I click ente
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 6:23 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley wrote:
When I type psql I am asked for a password. When I attempt to e
On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley wrote:
>
>
> -Original Message- From: Scott Marlowe
> Sent: Friday, December 24, 2010 6:23 PM
> To: Bob Pawley
> Cc: bricklen ; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Restore
>
> On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley wrote:
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 6:49 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent: Friday,
On Sat, Dec 18, 2010 at 10:23 PM, vvoody wrote:
> I have two servers, one primary and one standby, which doing warm
> standby. Every thing works fine at the beginning. The primary
> generates the archive WAL log files and the standby fetchs them to
> merge.
>
> Then, I want to let the standby beco
On 12/24/2010 07:09 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent: Friday, December 24, 2010 6:49 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley wrote:
-Original Messag
On Fri, Dec 24, 2010 at 8:09 PM, Bob Pawley wrote:
>
>
> -Original Message- From: Scott Marlowe
> Sent: Friday, December 24, 2010 6:49 PM
> To: Bob Pawley
> Cc: bricklen ; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Restore
>
> On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley wrote:
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:17 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:09 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent: Fr
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:17 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:09 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent: Fr
On Fri, Dec 24, 2010 at 8:29 PM, Bob Pawley wrote:
> Here is the result -
> c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -d PDW -U postgres -h
> localho
> st
> psql (8.4.5)
> WARNING: Console code page (850) differs from Windows code page (1252)
> 8-bit characters might not work corre
On 12/24/2010 07:29 PM, Bob Pawley wrote:
Here is the result -
c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -d PDW -U postgres -h
localho
st
psql (8.4.5)
WARNING: Console code page (850) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
pag
I tried PDW# \i PDW_June_2_2010.sql (\i FILE as per help)
My guess didn't work.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:33 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/
On 12/24/2010 07:46 PM, Bob Pawley wrote:
I tried PDW# \i PDW_June_2_2010.sql (\i FILE as per help)
My guess didn't work.
Bob
Is the file in the same directory as where you started psql? If not you
will need to provide the full path to the file. If it is then the error
messages would be nic
On Fri, Dec 24, 2010 at 8:46 PM, Bob Pawley wrote:
> I tried PDW# \i PDW_June_2_2010.sql (\i FILE as per help)
>
> My guess didn't work.
So what error did you get?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.
No error it just went back to PDW#
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 7:51 PM
To: Bob Pawley
Cc: Adrian Klaver ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 8:46 PM, Bob Pawley wrote:
I t
On 12/24/2010 07:51 PM, Scott Marlowe wrote:
On Fri, Dec 24, 2010 at 8:46 PM, Bob Pawley wrote:
I tried PDW# \i PDW_June_2_2010.sql (\i FILE as per help)
My guess didn't work.
So what error did you get?
Also might be good time to ask what is in the file. You said you where
trying a resto
Yes the file is in the postgresql bin and that is where I changed directory
to begin this saga.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:49 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
The file is an .sql file from a database dump - same procedure I have used a
number of times previous to this upgrade.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:53 PM
To: Scott Marlowe
Cc: Bob Pawley ; bricklen ; pgsql-general@postgresql.org
Subject:
On 12/24/2010 07:57 PM, Bob Pawley wrote:
The file is an .sql file from a database dump - same procedure I have
used a number of times previous to this upgrade.
Bob
What upgrade?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
I am installing 8.4 as I had problems with 8.3.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:59 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:57 PM, Bob Pawley wrote:
On 12/24/2010 08:03 PM, Bob Pawley wrote:
I am installing 8.4 as I had problems with 8.3.
Bob
Well that would have been nice to have known at the beginning of this.
At this point what versions do you have installed? As to errors have you
looked at the Postgres log?
--
Adrian Klaver
adrian
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:08 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:03 PM, Bob Pawley wrote:
I am installing 8.4 as I had problems with 8.3.
Bob
Wel
On 12/24/2010 08:15 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Friday, December 24, 2010 8:08 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:03 PM, Bob Pawley wrote:
I am installing 8
Thanks for hanging in there.
Merry Christmas to all.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:21 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:15 PM, Bob Pawley wrote:
I attempted loading earlier version of my backup database, using PDW# \I
PDW_May_2010 and it worked.
Looks as tho the June version may have been corrupt.
Thanks again for all of the help.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:21 PM
To: Bob Paw
63 matches
Mail list logo
