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
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:
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
-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: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
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 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)
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:
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
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
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 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.
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
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: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
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
-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: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:
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 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
-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 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: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: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
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: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
>>
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 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,
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 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
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 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:)
-
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
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 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
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_
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 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
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
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: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
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 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
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
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 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
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
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 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
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 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:
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: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
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
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
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
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
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
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
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
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'
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
63 matches
Mail list logo
