Just to add more info I made a "pg_dumpall | grep user1" to be sure that the
user was really created, which sounds to be the case :
CREATE USER user1 WITH SYSID 100 NOCREATEDB NOCREATEUSER;
> Hi there,
>
> I have a problem accessing my postgres database when using a
> specific user...
>
> If
I am having a hard time selecting a Replication/Failover/HA solution for
PGSQL. What is troubling is the number of solutions available in various
states of development. Does the fact that dbmirror and rserv appear in
the contrib directory, mean that they should be looked upon with more
legitim
There are some papers on the PostgreSQL web site, in the developers
section, and of course there is the source code, plus some stuff in the
admin docs.
---
Dani Oderbolz wrote:
> Hi everybody,
> maybe you have followed the t
At the risk of stating the obvious, also check to make sure Postmaster
is listening on port 5432. To do this log in as root and run /sbin/fuser
-vn tcp 5432. If postmaster is not listed it may only be running with
unix sockets. This measn that you must pass the -i flag to postmaster
when it sta
panon wrote:
> I was using Postgres 7.3.2 and later 7.3.3 on Red Hat 8 and everyhing
> worked fine. Yesterday we upgraded to Red Hat 9 (with 7.3.3 shipped)
> and since then I can't connect through TCP/IP to database. I am using
> latest ODBC drivers. Has Red Hat broken something in this release. I
> prod.dump.tar is the result of pg_dump, not a command, as for
> your text sample below.
> "pg_dump -Ft prod > prod.dump.tar" would be better.
Jean-Michel-
I'm sorry- that was a typo in my original post that I should have corrected.
The actual command that I'm using is in fact "pg_dump -Ft prod
Nick Fankhauser a écrit :
Hello-
I'm reposting this problem because I didn't receive any responses to the
first post that led to a resolution- Perhaps this is a bug, but I'll give it
another chance here before promoting it to the bugs list.
Since sending the information below, I've set up a nearl
Olivier-
The pg_hba.conf file controls how users connect to the database, but if the
user does not have grants on the specific table within the database, I think
you'd be getting an error similar to the one you describe. Does the user you
created either have "dba" privileges or select access on th
Hi there,
I have a problem accessing my postgres database when using a specific
user...
If I run and pg_dumpall using the postgres linux user I have no problem.
Then I tried to add a new user only for one database (let say "user1" and
"db1"). My pg_hba.conf looks like :
local all all
Nick Fankhauser wrote:
...
pg_dump: [tar archiver] could not write to tar member (wrote 39, attempted
166)
...
Hi Nick,
how big does your tar file get when you get the error?
I would guess that its 2GB at this time, which would indicate that you just
hit a File System Limit.
To prevent this,
Hi Dani-
The file is nowhere near 2GB, and a regular text dump running at the same
time always completes successfuly, with a resulting file size about 4 times
what the tar-format file was when it died. Also note that this worked on the
same server using the same database using v7.2 of postgreSQL.
Hi Valeria:
I have downloaded the set of postgresql-7.3.3-1PGDG RPM packages and
tried to install it on RedHat 8.0. On this server there was no other
PostgreSQL installation. After submitting the command below:
# rpm -ivh postgresql-7.3.3-1PGDG.i386.rpm
I received the following error messag
12 matches
Mail list logo
