Hello, PostGreSQL-Masters
System
PostGreSQL: 7.4.30 the postgres-installer ( postgresql-7.4.30.tar.gz)
OS: AIXv5.2 TL09 (POWER5)
Machine: 9119-590(1LPAR)
Status
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
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't
I'm trying to link up a C++ project with postgres functions, the following code
compiles (as C++):
extern C {
#include postgres.h
#include fmgr.h
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
};
extern C {
PG_FUNCTION_INFO_V1(pg_xversion);
};
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 elliotcha...@gmail.com
I'm trying to link up a C++ project with postgres functions, the following
code compiles (as C++):
extern C {
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 elliotcha...@gmail.com
I'm trying to link up a C++
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:
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
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:
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:
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
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
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 password with which
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:
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:
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 part showed
On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver adrian.kla...@gmail.com 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
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 (this
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
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 for
On Fri, Dec 24, 2010 at 5:03 PM, Bob Pawley rjpaw...@shaw.ca 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
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.
On Fri, Dec 24, 2010 at 6:00 PM, Bob Pawley rjpaw...@shaw.ca 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
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 needs to
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 rjpaw...@shaw.ca 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
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
On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawley rjpaw...@shaw.ca 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;
On Fri, Dec 24, 2010 at 5:03 PM, Bob Pawley rjpaw...@shaw.ca 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
On 12/24/10 6:09 PM, Scott Marlowe wrote:
On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawleyrjpaw...@shaw.ca 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
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
On Fri, Dec 24, 2010 at 7:12 PM, John R Pierce pie...@hogranch.com wrote:
On 12/24/10 6:09 PM, Scott Marlowe wrote:
On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawleyrjpaw...@shaw.ca wrote:
I didn't copy or paste anything. I just clicked Stop.
No, copy and paste WHAT YOU DID, from your screen
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 rjpaw...@shaw.ca 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?
-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 rjpaw...@shaw.ca wrote:
When I type psql I am asked for a password.
On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley rjpaw...@shaw.ca 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
-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 rjpaw...@shaw.ca wrote:
-Original Message- From: Scott
On Sat, Dec 18, 2010 at 10:23 PM, vvoody wxj.g...@gmail.com 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
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 rjpaw...@shaw.ca wrote:
On Fri, Dec 24, 2010 at 8:09 PM, Bob Pawley rjpaw...@shaw.ca 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
-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:
-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:
On Fri, Dec 24, 2010 at 8:29 PM, Bob Pawley rjpaw...@shaw.ca wrote:
Here is the result -
c:\Program Files (x86)\PostgresPlus\8.4SS\binpsql -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
On 12/24/2010 07:29 PM, Bob Pawley wrote:
Here is the result -
c:\Program Files (x86)\PostgresPlus\8.4SS\binpsql -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
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
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
On Fri, Dec 24, 2010 at 8:46 PM, Bob Pawley rjpaw...@shaw.ca 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:
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
On 12/24/2010 07:51 PM, Scott Marlowe wrote:
On Fri, Dec 24, 2010 at 8:46 PM, Bob Pawleyrjpaw...@shaw.ca 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
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
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
-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
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
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
63 matches
Mail list logo