[GENERAL] did freese in creating a database cluster

[Tsutomu Nakajima]

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 default max_connections..." did freeze,
and the status is the same although I have waited for 24 hours.

<>
1. What was the situation happend in creating a database cluster?
2. Would you please give me solution or workaround for this status?

<>
[postgres:/home/pp/postgres]initdb -D /usr/local/pgsql/data -d
Running in debug mode.

initdb: internal variables:
  PGDATA=/usr/local/pgsql/data
  datadir=/usr/local/pgsql/share
  PGPATH=/usr/local/pgsql/bin
  ENCODING=
  ENCODINGID=0
  POSTGRES_SUPERUSERNAME=postgres
  POSTGRES_BKI=/usr/local/pgsql/share/postgres.bki
  POSTGRES_DESCR=/usr/local/pgsql/share/postgres.description
  POSTGRESQL_CONF_SAMPLE=/usr/local/pgsql/share/postgresql.conf.sample
  PG_HBA_SAMPLE=/usr/local/pgsql/share/pg_hba.conf.sample
  PG_IDENT_SAMPLE=/usr/local/pgsql/share/pg_ident.conf.sample
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locales:
  COLLATE:  C
  CTYPE:C
  MESSAGES:
  MONETARY: C
  NUMERIC:  C
  TIME: C

fixing permissions on existing directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
selecting default max_connections...



Regards
Tsutomu

Re: [GENERAL] When the trigger is called my application is awaiting the finish

[Alban Hertroys]

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 wait for the end?

As usual, that depends. If running that function asynchronously from your 
update can not break referential integrity or cause dead-locks with your update 
(e.g. they aren't directly connected), then you can use LISTEN/NOTIFY to notify 
another process on a different connection that the function should be performed.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4d1473b6802655198511903!



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Load C++ for functions?

[Elliot Chance]

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" Datum pg_xversion(PG_FUNCTION_ARGS)
{
PG_RETURN_NULL();
}

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

Postgres is no doubt trying to load a C++ linked library as C - is there a way 
to fix this?
-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Load C++ for functions?

[Dmitriy Igrishin]

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" {
>#include 
>#include 
>
>#ifdef PG_MODULE_MAGIC
>PG_MODULE_MAGIC;
>#endif
> };
>
> extern "C" {
>PG_FUNCTION_INFO_V1(pg_xversion);
> };
> extern "C" Datum pg_xversion(PG_FUNCTION_ARGS)
> {
>PG_RETURN_NULL();
> }
>
> 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
>
> Postgres is no doubt trying to load a C++ linked library as C - is there a
> way to fix this?
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



-- 
// Dmitriy.

Re: [GENERAL] Load C++ for functions?

[Elliot Chance]

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 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" Datum pg_xversion(PG_FUNCTION_ARGS)
> {
>PG_RETURN_NULL();
> }
> 
> 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
> 
> Postgres is no doubt trying to load a C++ linked library as C - is there a 
> way to fix this?
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> 
> 
> 
> -- 
> // Dmitriy.
> 
> 

Re: [GENERAL] Load C++ for functions?

[Craig Ringer]

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 pgx.so' list libstdc++ as a dependency? Are you for some reason 
compiling with -fno-exceptions? Is every single one of your C++ 
functions wrapped with an unconditional try/catch that converts any 
exceptions to error return codes/Pg elog() calls?


I've written Pg extension modules, but I've always done so by compiling 
the component containing PG_MODULE_MAGIC, PG_FUNCTION_INFO_V1, 
PG_FUNCTION_ARGS, etc as regular C, and having it call "extern C" 
functions in the C++ files linked into the shared object. I don't 
*think* this should make any difference, but I'm far from a C/C++ expert.



Postgres is no doubt trying to load a C++ linked library as C - is there a way 
to fix this?


AFAIK, dlopen() doesn't care if a library is C, C++, or BlueLanguage, so 
long as it provides standard ELF symbols and a C-compatible entry point.


--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Load C++ for functions?

[Craig Ringer]

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.postgresql.org/mailpref/pgsql-general

[GENERAL] Restore

[Bob Pawley]

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 password of my computer - 
which doesn’t exist.

How can I get around this??

Bob

[GENERAL] Ownership/Permissions Problem

[Rich Shepard]

  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: Permission denied

  Yet, when I su to user postgres and run the command it loads the shell:

postg...@salmo:/home/rshepard$ psql aesi
psql (9.0.1)
Type "help" for help.

aesi=#

  What directory or file has the incorrect ownership and/or permissions, and
what should they be?

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ownership/Permissions Problem

[John R Pierce]

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.so.5: cannot open 
shared

object file: Permission denied

  Yet, when I su to user postgres and run the command it loads the shell:

postg...@salmo:/home/rshepard$ psql aesi
psql (9.0.1)
Type "help" for help.

aesi=#

  What directory or file has the incorrect ownership and/or 
permissions, and

what should they be?


wild guess says, libpq.so.5  or whatever its linked to.

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 138316 Dec 10  2009 /usr/lib/libpq.so.5.1


it doesn't really matter who owns it, what matters is the symlinked 
actual file has +rx (755 or whatever)






--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ownership/Permissions Problem

[Rich Shepard]

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 138316 Dec 10  2009 /usr/lib/libpq.so.5.1


  Here,

[r...@salmo ~]# ll /usr/local/pgsql/lib/libpq*
-rw-r--r-- 1 root root 191494 2010-12-14 10:08 /usr/local/pgsql/lib/libpq.a

lrwxrwxrwx 1 root root 12 2010-12-14 10:08 /usr/local/pgsql/lib/libpq.so
-> libpq.so.5.3*

lrwxrwxrwx 1 root root 12 2010-12-14 10:08
/usr/local/pgsql/lib/libpq.so.5 -> libpq.so.5.3*

-rwxr-xr-x 1 root root 153929 2010-12-14 10:08
/usr/local/pgsql/lib/libpq.so.5.3*

  So libpq.so.5.3 has 755 permissions.

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ownership/Permissions Problem

[John R Pierce]

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 -> 
libpq.so.5.1

-rwxr-xr-x 1 root root 138316 Dec 10  2009 /usr/lib/libpq.so.5.1


  Here,

[r...@salmo ~]# ll /usr/local/pgsql/lib/libpq*
-rw-r--r-- 1 root root 191494 2010-12-14 10:08 
/usr/local/pgsql/lib/libpq.a




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.


also, use

$ ldd `which psql`

to verify you're running the right files and libs.  oh, lots of libs 
there to check.   if you get errors, do this also from the 'postgres' 
user and compare.


$ ldd `which psql`
linux-gate.so.1 =>  (0x4000)
libpq.so.5 => /usr/lib/libpq.so.5 (0x00791000)
libxslt.so.1 => /usr/lib/libxslt.so.1 (0x0047f000)
libxml2.so.2 => /usr/lib/libxml2.so.2 (0x0097d000)
libpam.so.0 => /lib/libpam.so.0 (0x003f3000)
libssl.so.6 => /lib/libssl.so.6 (0x006e4000)
libcrypto.so.6 => /lib/libcrypto.so.6 (0x004d9000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0061c000)
libz.so.1 => /usr/lib/libz.so.1 (0x0030a000)
libreadline.so.5 => /usr/lib/libreadline.so.5 (0x0042e000)
libtermcap.so.2 => /lib/libtermcap.so.2 (0x00381000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x0038c000)
libdl.so.2 => /lib/libdl.so.2 (0x002c1000)
libm.so.6 => /lib/libm.so.6 (0x002c7000)
libc.so.6 => /lib/libc.so.6 (0x00179000)
libldap_r-2.3.so.0 => /usr/lib/libldap_r-2.3.so.0 (0x0074a000)
libpthread.so.0 => /lib/libpthread.so.0 (0x002f)
libaudit.so.0 => /lib/libaudit.so.0 (0x0072d000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x0064c000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x003ee000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00401000)
libresolv.so.2 => /lib/libresolv.so.2 (0x003d9000)
libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x004ce000)
libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x00429000)
/lib/ld-linux.so.2 (0x0015b000)
liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0x004b6000)
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x00464000)
libselinux.so.1 => /lib/libselinux.so.1 (0x00367000)
libsepol.so.1 => /lib/libsepol.so.1 (0x0031f000)



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ownership/Permissions Problem

[Rich Shepard]

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 appreciated; this has distracted me since last Sunday.

Happy holidays,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ownership/Permissions Problem

[Joshua D. Drake]

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 /usr/local/pgsql were 700. Changing them to
> 755 fixed everything.
> 

You will want to make sure you didn't do that
to /usr/local/pgsql/data . /usr/local/pgsql/data should be 700.

JD
-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Compress data sent to client

[pasman pasmański]

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

Re: [GENERAL] Restore

[Adrian Klaver]

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 I connect to the server but it is not
> accepted.
>
> Without the –U postgres identifier it asks me for the password of my
> computer - which doesn’t exist.

Without a specified -U it psql will use your system user name.
See here for all the gory details:
http://www.postgresql.org/docs/9.0/interactive/app-psql.html

>
> How can I get around this??
>
> Bob



-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ownership/Permissions Problem

[Rich Shepard]

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:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore

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 I connect to the server but it is not
accepted.

Without the –U postgres identifier it asks me for the password of my
computer - which doesn’t exist.


Without a specified -U it psql will use your system user name.
See here for all the gory details:
http://www.postgresql.org/docs/9.0/interactive/app-psql.html



How can I get around this??

Bob




--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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 that your form of connecting should 
work also i.e.psql –U postgres PDW < PDW_June_10.sql.
A couple of questions.
Can you connect to a database using psql and -U postgres?
Does the postgres user have a password?
If you can connect to a database with  psql what does \l show? What I am 
looking 
for is whether PDW has its case preserved or not?


-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[bricklen]

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 get
>> password failed.
>>
>> Bob
>>
>
> A little bit of testing on my part showed that your form of connecting should
> work also i.e.psql –U postgres PDW < PDW_June_10.sql.
> A couple of questions.
> Can you connect to a database using psql and -U postgres?
> Does the postgres user have a password?
> If you can connect to a database with  psql what does \l show? What I am 
> looking
> for is whether PDW has its case preserved or not?

How about the pg_hba.conf setting? Is it set to something like md5?

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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 password it either said password failed or it simply went 
back to the root command.


No database information was sent.

pg_hba.conf sets method as md5

I don't know what is meant by your reference to  \1.

Bob


-Original Message- 
From: bricklen

Sent: Friday, December 24, 2010 3:47 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore

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 get
password failed.

Bob



A little bit of testing on my part showed that your form of connecting 
should

work also i.e.psql –U postgres PDW < PDW_June_10.sql.
A couple of questions.
Can you connect to a database using psql and -U postgres?
Does the postgres user have a password?
If you can connect to a database with  psql what does \l show? What I am 
looking

for is whether PDW has its case preserved or not?


How about the pg_hba.conf setting? Is it set to something like md5?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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 makes sense and which I did enter).
>
> When I entered the password it either said password failed or it simply
> went back to the root command.
>
> No database information was sent.
>
> pg_hba.conf sets method as md5
>
> I don't know what is meant by your reference to  \1.
>
> Bob
>

Lets go back to the beginning. 
Basic info:
Pg version
OS
How do you normally connect to the database?
Have you set up passwords for Postgres users?
Remember Postgres users are not the same as system users. So when it asking for 
a password it is for the Postgres users password not the system users password 
of the same name.

-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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 postgres user other than what PG Admin uses.

Bob

-Original Message- 
From: Adrian Klaver

Sent: Friday, December 24, 2010 4:09 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley ; bricklen
Subject: Re: [GENERAL] Restore

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 makes sense and which I did enter).

When I entered the password it either said password failed or it simply
went back to the root command.

No database information was sent.

pg_hba.conf sets method as md5

I don't know what is meant by your reference to  \1.

Bob



Lets go back to the beginning.
Basic info:
Pg version
OS
How do you normally connect to the database?
Have you set up passwords for Postgres users?
Remember Postgres users are not the same as system users. So when it asking 
for
a password it is for the Postgres users password not the system users 
password

of the same name.

--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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 the restore
> connection.

The installation of what Postgres or PgAdmin? 
I don't use PgAdmin so I going out on a limb here. Is there a way in PgAdmin to 
look at users? If so it should show you whether the postgres user has a 
password.

> I haven`t done anything for the postgres user other than what PG Admin
> uses.
>
> Bob


-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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 (this makes sense and which I did enter).
>
> When I entered the password it either said password failed or it simply went
> back to the root command.

Keep in mind, the password set for the unix account is NOT related to
the password set for a user in postgresql with alter user password =
'mypassword';.

If you are entering a unix password for a pg account that hasn't had
the pw set, then it's not going to work.  They're not related at all.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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.

Maybe I need to delete the postgres database.

Bob





-Original Message- 
From: Adrian Klaver

Sent: Friday, December 24, 2010 4:27 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org ; bricklen
Subject: Re: [GENERAL] Restore

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 the restore
connection.


The installation of what Postgres or PgAdmin?
I don't use PgAdmin so I going out on a limb here. Is there a way in PgAdmin 
to

look at users? If so it should show you whether the postgres user has a
password.


I haven`t done anything for the postgres user other than what PG Admin
uses.

Bob



--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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_postgis.

And there's also a postgres user.  Change pg_hba.conf to use trust,
reload pgsql, log in, and issue a \du and you'll see all the users.

> The postgres database probably has a password.

databases do not have individual passwords.  Users do.

> Maybe I need to delete the postgres database.

No, that won't change this issue.

Whether or not a particular connection type needs a password or not is
determined by the pg_hba.conf file.  Change that to trust, ident (for
local connections) or md5 as you need.  First match is what you need.
I.e. if you have local unix socket and tcp connections set to trust,
then later entries won't really matter.  pg_hba.conf is pretty close
to self documenting really.

After setting it reload or restart pgsql and you can log in according
to the method you set in pg_hba.conf.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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 be a 
user(role actually) so the user that owns PDW is postgres. To make things a 
little more complicated the system user that Postgres is run as is also usually 
called postgres. This is why I am trying to figure out which password you are 
using. In order for it to work to connect to Postgres it needs to be the 
password associated with the database user postgres not the system user 
postgres. If you are using the password that the Postgres installer used to set 
up the system postgres user that is the wrong one. The one you want is the one 
you used when you set up the Server properties in PgAdmin.

>
> My PG Admin shows postgres as a database along with PDW and
> template_postgis.

The postgres database is a system db set up along with template0 and template1 
when a Postgres database cluster is first created.

>
> The postgres database probably has a password.



>
> Maybe I need to delete the postgres database.

No don't do that. It is basically empty and can be recreated if needed but 
there 
is no need to delete it.

> Bob
>
>


-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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 ; bricklen
Subject: Re: [GENERAL] Restore

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 
be a

user(role actually) so the user that owns PDW is postgres. To make things a
little more complicated the system user that Postgres is run as is also 
usually
called postgres. This is why I am trying to figure out which password you 
are

using. In order for it to work to connect to Postgres it needs to be the
password associated with the database user postgres not the system user
postgres. If you are using the password that the Postgres installer used to 
set
up the system postgres user that is the wrong one. The one you want is the 
one

you used when you set up the Server properties in PgAdmin.



My PG Admin shows postgres as a database along with PDW and
template_postgis.


The postgres database is a system db set up along with template0 and 
template1

when a Postgres database cluster is first created.



The postgres database probably has a password.






Maybe I need to delete the postgres database.


No don't do that. It is basically empty and can be recreated if needed but 
there

is no need to delete it.


Bob





--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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 list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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:) 


-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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, 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 list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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
smarlowe=# alter user joe with password='xyz';
ERROR:  syntax error at or near "="
LINE 1: alter user joe with password='xyz';
^
smarlowe=# alter user joe with password 'xyz';
ALTER ROLE
smarlowe=# \q
smarl...@breckenridge:~$ psql -U jpe
psql: FATAL:  Ident authentication failed for user "jpe"
smarl...@breckenridge:~$ psql -U joe
psql: FATAL:  Ident authentication failed for user "joe"
smarl...@breckenridge:~$

So we're not guessing at what you're seeing.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[John R Pierce]

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, 
spare us.




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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.  I'll just cut most of the previous and
put it at the bottom.

On Fri, Dec 24, 2010 at 6:20 PM, Bob Pawley  wrote:
> -Original Message- From: Adrian Klaver
> On Friday 24 December 2010 5:00:19 pm Bob Pawley wrote:
>>
>>> The postgres database probably has a password.
>>> Maybe I need to delete the postgres database.
>
>> No don't do that. It is basically empty and can be recreated if needed but
>> there
>> is no need to delete it.

> I just stopped the server after changing config to trust and I got the
> message `System error 5 has occurred. Access is denied`

So I see you're running windows so I too am now out of my area of
expertise.  Can you show us the changes you made configuration wise?
They might provide a clue.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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
>> this:
>
> he's on MS Windows 7.  you want him to email screen shots?  please, spare
> us.

Yeah I just noticed that.  Thanks for the professional and polite
reply.  I would like to see copy and pastes of relavent things, like
configuration cahnges.  Seems reasonable to ask for as much info as he
can throw at us to let us see what he sees and know what he did.
Right now we're like a group of blind men inspecting an elephant from
different angles.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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 24, 2010 6:12 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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 enter I get failed password for - my computer name.

Hmmm.  Again, please copy and paste exactly what it says.

> When I type psql \I -  I get the same as above.

Yeah, until you can log in psql \l isn't going to work.  Once you can
log in it should work.

So, yeah.  cut and paste your psql session first, k?

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

-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 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 enter I get failed password for - my computer name.


Hmmm.  Again, please copy and paste exactly what it says.


When I type psql \I -  I get the same as above.


Yeah, until you can log in psql \l isn't going to work.  Once you can
log in it should work.

So, yeah.  cut and paste your psql session first, k?

Is this what you meant by psql session??

2010-12-24 11:08:46 PSTLOG:  database system was shut down at 2010-12-24 
11:07:13 PST

2010-12-24 11:08:46 PSTFATAL:  the database system is starting up
2010-12-24 11:08:47 PSTFATAL:  the database system is starting up
2010-12-24 11:08:48 PSTFATAL:  the database system is starting up
2010-12-24 11:08:49 PSTLOG:  database system is ready to accept connections
2010-12-24 11:08:49 PSTLOG:  autovacuum launcher started
2010-12-24 11:21:25 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:35 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:39 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:50 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:54 PSTWARNING:  pgstat wait timeout
2010-12-24 11:22:05 PSTWARNING:  pgstat wait timeout
2010-12-24 11:32:38 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 12:11:09 PSTFATAL:  password authentication failed for user "-U"
2010-12-24 12:18:50 PSTFATAL:  password authentication failed for user 
"psql"
2010-12-24 15:27:40 PSTFATAL:  password authentication failed for user 
"postgres"
2010-12-24 15:41:10 PSTFATAL:  password authentication failed for user 
"postgresql"

2010-12-24 15:44:15 PSTFATAL:  password authentication failed for user "PDW"
2010-12-24 15:50:13 PSTFATAL:  password authentication failed for user 
"postgresql"

2010-12-24 16:08:49 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 18:13:34 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 18:17:25 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 18:19:05 PSTFATAL:  password authentication failed for user "Bob"


Bob

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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:
>>
>> 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 enter I get failed password for - my computer name.
>
> Hmmm.  Again, please copy and paste exactly what it says.
>
>> When I type psql \I -  I get the same as above.
>
> Yeah, until you can log in psql \l isn't going to work.  Once you can
> log in it should work.
>
> So, yeah.  cut and paste your psql session first, k?
>
> Is this what you meant by psql session??

No, that's the pgsql log, which is also quite useful.  So, when you
bring up a command prompt and type in psql -U bob wwwdb or something
like that and it says something about a password failure, that's the
stuff I'd like you to cut and paste.  The accompanying postgresql like
this one here would be useful too.

>
> 2010-12-24 11:08:46 PSTLOG:  database system was shut down at 2010-12-24
> 11:07:13 PST
> 2010-12-24 11:08:46 PSTFATAL:  the database system is starting up
> 2010-12-24 11:08:47 PSTFATAL:  the database system is starting up
> 2010-12-24 11:08:48 PSTFATAL:  the database system is starting up
> 2010-12-24 11:08:49 PSTLOG:  database system is ready to accept connections
> 2010-12-24 11:08:49 PSTLOG:  autovacuum launcher started
> 2010-12-24 11:21:25 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:35 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:39 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:50 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:54 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:22:05 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:32:38 PSTFATAL:  password authentication failed for user "Bob"
> 2010-12-24 12:11:09 PSTFATAL:  password authentication failed for user "-U"
> 2010-12-24 12:18:50 PSTFATAL:  password authentication failed for user
> "psql"
> 2010-12-24 15:27:40 PSTFATAL:  password authentication failed for user
> "postgres"
> 2010-12-24 15:41:10 PSTFATAL:  password authentication failed for user
> "postgresql"
> 2010-12-24 15:44:15 PSTFATAL:  password authentication failed for user "PDW"
> 2010-12-24 15:50:13 PSTFATAL:  password authentication failed for user
> "postgresql"
> 2010-12-24 16:08:49 PSTFATAL:  password authentication failed for user "Bob"
> 2010-12-24 18:13:34 PSTFATAL:  password authentication failed for user "Bob"
> 2010-12-24 18:17:25 PSTFATAL:  password authentication failed for user "Bob"
> 2010-12-24 18:19:05 PSTFATAL:  password authentication failed for user "Bob"

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[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  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 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 enter I get failed password for - my computer name.


Hmmm.  Again, please copy and paste exactly what it says.


When I type psql \I -  I get the same as above.


Yeah, until you can log in psql \l isn't going to work.  Once you can
log in it should work.

So, yeah.  cut and paste your psql session first, k?

Is this what you meant by psql session??


No, that's the pgsql log, which is also quite useful.  So, when you
bring up a command prompt and type in psql -U bob wwwdb or something
like that and it says something about a password failure, that's the
stuff I'd like you to cut and paste.  The accompanying postgresql like
this one here would be useful too.



2010-12-24 11:08:46 PSTLOG:  database system was shut down at 2010-12-24
11:07:13 PST
2010-12-24 11:08:46 PSTFATAL:  the database system is starting up
2010-12-24 11:08:47 PSTFATAL:  the database system is starting up
2010-12-24 11:08:48 PSTFATAL:  the database system is starting up
2010-12-24 11:08:49 PSTLOG:  database system is ready to accept 
connections

2010-12-24 11:08:49 PSTLOG:  autovacuum launcher started
2010-12-24 11:21:25 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:35 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:39 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:50 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:54 PSTWARNING:  pgstat wait timeout
2010-12-24 11:22:05 PSTWARNING:  pgstat wait timeout
2010-12-24 11:32:38 PSTFATAL:  password authentication failed for user 
"Bob"
2010-12-24 12:11:09 PSTFATAL:  password authentication failed for user 
"-U"

2010-12-24 12:18:50 PSTFATAL:  password authentication failed for user
"psql"
2010-12-24 15:27:40 PSTFATAL:  password authentication failed for user
"postgres"
2010-12-24 15:41:10 PSTFATAL:  password authentication failed for user
"postgresql"
2010-12-24 15:44:15 PSTFATAL:  password authentication failed for user 
"PDW"

2010-12-24 15:50:13 PSTFATAL:  password authentication failed for user
"postgresql"
2010-12-24 16:08:49 PSTFATAL:  password authentication failed for user 
"Bob"
2010-12-24 18:13:34 PSTFATAL:  password authentication failed for user 
"Bob"
2010-12-24 18:17:25 PSTFATAL:  password authentication failed for user 
"Bob"
2010-12-24 18:19:05 PSTFATAL:  password authentication failed for user 
"Bob"



Following is the copy of the command prompt

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Bob>cd c:\program files (x86)\postgresplus\8.4ss\bin

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW < PDW_June_2_2010.sql
Password: calgary0623

psql: FATAL:  password authentication failed for user "Bob"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW < PDW_June_2_2010.sql
Password:

psql: fe_sendauth: no password supplied

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW -U postgres < 
PDW_June_2_

2010.sql
psql: warning: extra command-line argument "postgres" ignored
Password for user -U: calgary0623

psql: FATAL:  password authentication failed for user "-U"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -h localhost -U psql -d 
PDW <

PDW_June_2_2010.backup
Password for user psql: calgary0623

psql: FATAL:  password authentication failed for user "psql"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -u postgres PDW < 
PDW_June_2_

2010.sql
psql: illegal option -- u
Try "psql --help" for more information.

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW < 
PDW_June_2_

2010.sql
Password for user postgres: calgary0623


c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW < PDW_June_2_2010.sql
Password:

psql: fe_sendauth: no password supplied

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres -d PDW -f 
PDW_Jun

e_2_2010.sql
Password for user postgres:

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U 
postgres -fPDW_June_2_2010

.sql
Password for user postgres:
psql: FATAL:  password authentication failed for user "postgres"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgresql
Password for user postgresql:
psql: FATAL:  password authentication failed for user "postgresql"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>
c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW 

010.sql
The system cannot find the file spe

Re: [GENERAL] Have any tricks not to recreate a standby server to switch to the former primary?

[Josh Kupershmidt]

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 become primary. So I stop the
> postgresql(service postgresql stop) manually, copy the last WAL file
> and files under pg_xlog/ to the standby. The former standby now
> becomes primary and the data is ok. BTW, it still started as archive
> mode.

I follow you up to here. Presumably, you instantiated the standby
using the steps outlined here:
http://wiki.postgresql.org/wiki/Warm_Standby

> Not end yet. After the standby running for a while and generating some
> data, I want to switch back to the former primary. And I repeat the
> above steps: stop the postgresql service manuall, copy WAL log files
> and files under pg_xlog/ to the former primary. I delete the pg_xlog/
> and files under archive directory. Then the postgresql starts, but the
> data generated after last switching do not come over.

>From this description, it sounds like you're trying to shortcut the
process of bringing your old primary server (server A) up-to-date with
the currently-running server (server B). In order to bring server A
up-to-date with B, you'll need to follow *all* the steps on that wiki
page to set server A up as a warm standby of B, particularly the
pg_start_backup(); rsync'ing of PGDATA over to A, etc.

Josh

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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 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 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 enter I get failed password for - my computer name.


Hmmm. Again, please copy and paste exactly what it says.


When I type psql \I - I get the same as above.


Yeah, until you can log in psql \l isn't going to work. Once you can
log in it should work.

So, yeah. cut and paste your psql session first, k?

Is this what you meant by psql session??


No, that's the pgsql log, which is also quite useful. So, when you
bring up a command prompt and type in psql -U bob wwwdb or something
like that and it says something about a password failure, that's the
stuff I'd like you to cut and paste. The accompanying postgresql like
this one here would be useful too.





Lets stick with on thing. For now use the following:

psql -d PDW -U postgres -h localhost

At this point it is important to be clear on what password you are using 
for the postgres user. As I posted before it should be the one you used 
when filling out the Server properties in PgAdmin. Is that the case?
We will worry about loading the file once we have figured out what it 
takes to connect.



--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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: 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 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 enter I get failed password for - my computer name.
>>
>> Hmmm.  Again, please copy and paste exactly what it says.
>>
>>> When I type psql \I -  I get the same as above.
>>
>> Yeah, until you can log in psql \l isn't going to work.  Once you can
>> log in it should work.
>>
>> So, yeah.  cut and paste your psql session first, k?
>>
>> Is this what you meant by psql session??
>
> No, that's the pgsql log, which is also quite useful.  So, when you
> bring up a command prompt and type in psql -U bob wwwdb or something
> like that and it says something about a password failure, that's the
> stuff I'd like you to cut and paste.  The accompanying postgresql like
> this one here would be useful too.
>
>>
>> 2010-12-24 11:08:46 PSTLOG:  database system was shut down at 2010-12-24
>> 11:07:13 PST
>> 2010-12-24 11:08:46 PSTFATAL:  the database system is starting up
>> 2010-12-24 11:08:47 PSTFATAL:  the database system is starting up
>> 2010-12-24 11:08:48 PSTFATAL:  the database system is starting up

SNIP

>> 2010-12-24 18:17:25 PSTFATAL:  password authentication failed for user
>> "Bob"
>> 2010-12-24 18:19:05 PSTFATAL:  password authentication failed for user
>> "Bob"
>
>
> Following is the copy of the command prompt
>
> Microsoft Windows [Version 6.1.7600]
> Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

SNIP

> c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql
> Password:
> psql: FATAL:  password authentication failed for user "Bob"

So have you at any time before this set a password for any user within
postgres (remember, a postgres account and password are not the same
as an OS user and password.  Have you issued a command that went
through in pgadmin or psql that changed / set a password for any
account?

Do this if you can:

Change pg_hba.conf to change all methods from md5 or ident to trust.
Save the original file.  restart pgsql.  If it won't restart, then
show us the changes from the file before and after you edited it.  If
it does work, then try to log in as postgres:

psql -U postgres postgres

First arg is db, second is user.

See if that works.  If it doesn't, copy and paste that psql terminal
session for us to look at.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[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: 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, 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 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 enter I get failed password for - my computer name.


Hmmm. Again, please copy and paste exactly what it says.


When I type psql \I - I get the same as above.


Yeah, until you can log in psql \l isn't going to work. Once you can
log in it should work.

So, yeah. cut and paste your psql session first, k?

Is this what you meant by psql session??


No, that's the pgsql log, which is also quite useful. So, when you
bring up a command prompt and type in psql -U bob wwwdb or something
like that and it says something about a password failure, that's the
stuff I'd like you to cut and paste. The accompanying postgresql like
this one here would be useful too.





Lets stick with on thing. For now use the following:

psql -d PDW -U postgres -h localhost

At this point it is important to be clear on what password you are using
for the postgres user. As I posted before it should be the one you used
when filling out the Server properties in PgAdmin. Is that the case?
We will worry about loading the file once we have figured out what it
takes to connect.


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
page "Notes for Windows users" for details.
Type "help" for help.

PDW=#

--
Adrian Klaver
adrian.kla...@gmail.com 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[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: 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, 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 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 enter I get failed password for - my computer name.


Hmmm. Again, please copy and paste exactly what it says.


When I type psql \I - I get the same as above.


Yeah, until you can log in psql \l isn't going to work. Once you can
log in it should work.

So, yeah. cut and paste your psql session first, k?

Is this what you meant by psql session??


No, that's the pgsql log, which is also quite useful. So, when you
bring up a command prompt and type in psql -U bob wwwdb or something
like that and it says something about a password failure, that's the
stuff I'd like you to cut and paste. The accompanying postgresql like
this one here would be useful too.





Lets stick with on thing. For now use the following:

psql -d PDW -U postgres -h localhost

At this point it is important to be clear on what password you are using
for the postgres user. As I posted before it should be the one you used
when filling out the Server properties in PgAdmin. Is that the case?
We will worry about loading the file once we have figured out what it
takes to connect.

There is only one password that I entered during the installation and I used 
the same password to connect PG Admin.


Bob
--
Adrian Klaver
adrian.kla...@gmail.com 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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 correctly. See psql reference
>        page "Notes for Windows users" for details.
> Type "help" for help.
>
> PDW=#

Cool, so you're in.  now you can use \u to see what your usernames
are.  you can use alter user to change / set the password for postgres
and the other users as well now.

Then you can change pg_hba.conf back to md5 and when it asks for a
password try the one you just set.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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
page "Notes for Windows users" for details.
Type "help" for help.

PDW=#



You are connected. PDW=# is the psql propmpt

--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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/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
page "Notes for Windows users" for details.
Type "help" for help.

PDW=#



You are connected. PDW=# is the psql propmpt

--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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 nice.



--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Scott Marlowe]

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.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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 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.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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 restore. Is the file a complete plain text database dump?


--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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: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 nice.


--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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: 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 restore. Is the file a complete plain text database dump?

--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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:

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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

-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


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?


Version 8.4.1 is installed.

The same log as I sent before.

2010-12-24 11:08:46 PSTLOG:  database system was shut down at 2010-12-24 
11:07:13 PST

2010-12-24 11:08:46 PSTFATAL:  the database system is starting up
2010-12-24 11:08:47 PSTFATAL:  the database system is starting up
2010-12-24 11:08:48 PSTFATAL:  the database system is starting up
2010-12-24 11:08:49 PSTLOG:  database system is ready to accept connections
2010-12-24 11:08:49 PSTLOG:  autovacuum launcher started
2010-12-24 11:21:25 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:35 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:39 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:50 PSTWARNING:  pgstat wait timeout
2010-12-24 11:21:54 PSTWARNING:  pgstat wait timeout
2010-12-24 11:22:05 PSTWARNING:  pgstat wait timeout
2010-12-24 11:32:38 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 12:11:09 PSTFATAL:  password authentication failed for user "-U"
2010-12-24 12:18:50 PSTFATAL:  password authentication failed for user 
"psql"
2010-12-24 15:27:40 PSTFATAL:  password authentication failed for user 
"postgres"
2010-12-24 15:41:10 PSTFATAL:  password authentication failed for user 
"postgresql"

2010-12-24 15:44:15 PSTFATAL:  password authentication failed for user "PDW"
2010-12-24 15:50:13 PSTFATAL:  password authentication failed for user 
"postgresql"

2010-12-24 16:08:49 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 18:13:34 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 18:17:25 PSTFATAL:  password authentication failed for user "Bob"
2010-12-24 18:19:05 PSTFATAL:  password authentication failed for user "Bob"

--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Adrian Klaver]

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.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?


Version 8.4.1 is installed.

The same log as I sent before.

2010-12-24 11:08:46 PSTLOG: database system was shut down at 2010-12-24
11:07:13 PST
2010-12-24 11:08:46 PSTFATAL: the database system is starting up
2010-12-24 11:08:47 PSTFATAL: the database system is starting up
2010-12-24 11:08:48 PSTFATAL: the database system is starting up
2010-12-24 11:08:49 PSTLOG: database system is ready to accept connections
2010-12-24 11:08:49 PSTLOG: autovacuum launcher started
2010-12-24 11:21:25 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:35 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:39 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:50 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:54 PSTWARNING: pgstat wait timeout
2010-12-24 11:22:05 PSTWARNING: pgstat wait timeout
2010-12-24 11:32:38 PSTFATAL: password authentication failed for user "Bob"
2010-12-24 12:11:09 PSTFATAL: password authentication failed for user "-U"
2010-12-24 12:18:50 PSTFATAL: password authentication failed for user
"psql"
2010-12-24 15:27:40 PSTFATAL: password authentication failed for user
"postgres"
2010-12-24 15:41:10 PSTFATAL: password authentication failed for user
"postgresql"
2010-12-24 15:44:15 PSTFATAL: password authentication failed for user "PDW"
2010-12-24 15:50:13 PSTFATAL: password authentication failed for user
"postgresql"
2010-12-24 16:08:49 PSTFATAL: password authentication failed for user "Bob"
2010-12-24 18:13:34 PSTFATAL: password authentication failed for user "Bob"
2010-12-24 18:17:25 PSTFATAL: password authentication failed for user "Bob"
2010-12-24 18:19:05 PSTFATAL: password authentication failed for user "Bob"



Your computer clock is correct? The last entry is for 18:19:05 PST where 
the time is currently Fri Dec 24 20:19:47 PST 2010. At any rate I am 
going to have to bow for now, the elves are getting cranky:)


--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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:


-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


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?


Version 8.4.1 is installed.

The same log as I sent before.

2010-12-24 11:08:46 PSTLOG: database system was shut down at 2010-12-24
11:07:13 PST
2010-12-24 11:08:46 PSTFATAL: the database system is starting up
2010-12-24 11:08:47 PSTFATAL: the database system is starting up
2010-12-24 11:08:48 PSTFATAL: the database system is starting up
2010-12-24 11:08:49 PSTLOG: database system is ready to accept connections
2010-12-24 11:08:49 PSTLOG: autovacuum launcher started
2010-12-24 11:21:25 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:35 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:39 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:50 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:54 PSTWARNING: pgstat wait timeout
2010-12-24 11:22:05 PSTWARNING: pgstat wait timeout
2010-12-24 11:32:38 PSTFATAL: password authentication failed for user 
"Bob"

2010-12-24 12:11:09 PSTFATAL: password authentication failed for user "-U"
2010-12-24 12:18:50 PSTFATAL: password authentication failed for user
"psql"
2010-12-24 15:27:40 PSTFATAL: password authentication failed for user
"postgres"
2010-12-24 15:41:10 PSTFATAL: password authentication failed for user
"postgresql"
2010-12-24 15:44:15 PSTFATAL: password authentication failed for user 
"PDW"

2010-12-24 15:50:13 PSTFATAL: password authentication failed for user
"postgresql"
2010-12-24 16:08:49 PSTFATAL: password authentication failed for user 
"Bob"
2010-12-24 18:13:34 PSTFATAL: password authentication failed for user 
"Bob"
2010-12-24 18:17:25 PSTFATAL: password authentication failed for user 
"Bob"
2010-12-24 18:19:05 PSTFATAL: password authentication failed for user 
"Bob"




Your computer clock is correct? The last entry is for 18:19:05 PST where
the time is currently Fri Dec 24 20:19:47 PST 2010. At any rate I am
going to have to bow for now, the elves are getting cranky:)

--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Restore

[Bob Pawley]

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 Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore

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.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?


Version 8.4.1 is installed.

The same log as I sent before.

2010-12-24 11:08:46 PSTLOG: database system was shut down at 2010-12-24
11:07:13 PST
2010-12-24 11:08:46 PSTFATAL: the database system is starting up
2010-12-24 11:08:47 PSTFATAL: the database system is starting up
2010-12-24 11:08:48 PSTFATAL: the database system is starting up
2010-12-24 11:08:49 PSTLOG: database system is ready to accept connections
2010-12-24 11:08:49 PSTLOG: autovacuum launcher started
2010-12-24 11:21:25 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:35 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:39 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:50 PSTWARNING: pgstat wait timeout
2010-12-24 11:21:54 PSTWARNING: pgstat wait timeout
2010-12-24 11:22:05 PSTWARNING: pgstat wait timeout
2010-12-24 11:32:38 PSTFATAL: password authentication failed for user 
"Bob"

2010-12-24 12:11:09 PSTFATAL: password authentication failed for user "-U"
2010-12-24 12:18:50 PSTFATAL: password authentication failed for user
"psql"
2010-12-24 15:27:40 PSTFATAL: password authentication failed for user
"postgres"
2010-12-24 15:41:10 PSTFATAL: password authentication failed for user
"postgresql"
2010-12-24 15:44:15 PSTFATAL: password authentication failed for user 
"PDW"

2010-12-24 15:50:13 PSTFATAL: password authentication failed for user
"postgresql"
2010-12-24 16:08:49 PSTFATAL: password authentication failed for user 
"Bob"
2010-12-24 18:13:34 PSTFATAL: password authentication failed for user 
"Bob"
2010-12-24 18:17:25 PSTFATAL: password authentication failed for user 
"Bob"
2010-12-24 18:19:05 PSTFATAL: password authentication failed for user 
"Bob"




Your computer clock is correct? The last entry is for 18:19:05 PST where
the time is currently Fri Dec 24 20:19:47 PST 2010. At any rate I am
going to have to bow for now, the elves are getting cranky:)

--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general 



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general