"Michael J. Robinson" <[EMAIL PROTECTED]> writes:
> When I try to login I get the following error:
> [EMAIL PROTECTED] postgressql]# psql template1 -U foo --password
> Password:
> psql: FATAL: IDENT authentication failed for user "foo"
The prompt tells the tale: you aren't "foo", you are "root".
Title: Meddelande
Fisrt
of all you are correct on the upgrade issue - the upgrade will only upgrade the
release version, not betas.
That
is not the problem. The MSIHANDLE problem is a known issue, but it doesn't
really matter. The problem is the crashing in CheckAvailableDLLs - you'll noti
Title: Problem setting up new users
I’m having problems setting up postgres with new users. It is a new install using 7.3..8 rpms. Use the following to create a new user.
create USER foo WITH PASSWORD 'secret';
When I try to login I get the following error:
[root@host postgressql]# psql
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Although I dislike last-minute fixes, I am strongly tempted to put in
>> the ignore-datallowconn-if-standalone change in all the releases we
>> are about to make.
> That sounds very reasonable.
Done.
regard
Hi,
I had PostgreSQL 8.0.0-beta5 on my Windows Xp home
laptop. It installed and ran fine.
After downloading v 8.0.2. I tried to run the
upgrade.bat script, but it choked and told me to run the main msi file. I then
assumed the upgrade wouldn't work and uninstalled
the beta just in case.
Tom Lane wrote:
> Although I dislike last-minute fixes, I am strongly tempted to put in
> the ignore-datallowconn-if-standalone change in all the releases we
> are about to make.
That sounds very reasonable.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
--
"David F. Skoll" <[EMAIL PROTECTED]> writes:
> Supposing someone stupidly did this:
> UPDATE pg_database SET datallowconn = false;
> and then closed all the connections to the server.
> Is there any way to recover short of nuking everything and
> restoring from a backup dump? :-(
BTW, am I
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Rosser Schwarz <[EMAIL PROTECTED]> writes:
> but a priori, I'd suggest trying, as your postgres user:
> $ createdb oopswow
Doesn't work because createdb has to connect to something (typically
template1). If he's closed off *all* his databases, he's in deep
doo-doo.
This is reminiscent of the pr
Alvaro Herrera wrote:
> Connect in standalone mode?
Does not work. Tom Lane replied with the only thing that does work,
which we independently discovered about 30 seconds before hearing from
Tom. :-)
The solution is to modify the PostgreSQL source code to skip the check,
and run the modified bi
On Thu, May 05, 2005 at 01:14:26PM -0400, David F. Skoll wrote:
> Hi,
>
> Supposing someone stupidly did this:
>
> UPDATE pg_database SET datallowconn = false;
>
> and then closed all the connections to the server.
>
> Is there any way to recover short of nuking everything and
> restoring
while you weren't looking, David F. Skoll wrote:
> Is there any way to recover short of nuking everything and
> restoring from a backup dump? :-(
I don't have any ability to test this and see if it actually works,
but a priori, I'd suggest trying, as your postgres user:
$ createdb oopswow
$ psql
"David F. Skoll" <[EMAIL PROTECTED]> writes:
> Supposing someone stupidly did this:
> UPDATE pg_database SET datallowconn = false;
> and then closed all the connections to the server.
> Is there any way to recover short of nuking everything and
> restoring from a backup dump? :-(
That would
Hi,
Supposing someone stupidly did this:
UPDATE pg_database SET datallowconn = false;
and then closed all the connections to the server.
Is there any way to recover short of nuking everything and
restoring from a backup dump? :-(
Regards,
David.
---(end of bro
Gourish
I have worked on a similar project
If you are interested give me a call or we can go back and forth
here.
Enthusiastically,
Dave Leedom
At 08:22 AM 5/5/2005, Gourish Singbal wrote:
I need help to transfer
data from postgreql to oracle database on
regular basis.
The original productin ap
I need help to transfer data from postgreql to oracle database on
regular basis.
The original productin application runs on oracle.
We need this setup temporarily for certain time period till we are
confortable that our application can survive on postgresql.
Please help if somebody has worked on
16 matches
Mail list logo
