Subbiah Stalin-XCGF84 wrote:
The following is the message we had got while setting up postgres
database. This message was overlooked when we setup but now we have
found the discrepancies. For now the database are created with encode
type as UTF8 but the locale settings are ISO8859-1 in postgres
I think I just made a huge error. I just upgraded all of my systems and in
the process I just upgraded the data base from 8.1 to 8.3. At least I think
it was 8.1. Anyway the postmaster won't run and I can't backup the old
database without a hue effort. Is there a way around this or do I have to
Hi,
We had sata raid controller failure causing one dead harddrive and one
that we managed to get all the data from in some experts lab.
We were running postgres 8.2 using the debian (codename lenny) package 8.2
Since the data is much more important to us then its integrity we
decided not to use
Group,
I have a postgres implementation with approximately 150 databases.
This was not my choice, but what I was given.
What I need to do is backup individual databases and be able to
restore any database along with it's roles. I understand the pg_dump
and restore commands, they are quite clear a
Julie Warden wrote:
> Is there a method to dump just the roles from a database, or otherwise
> select them, so I can build a script to reload the roles? Otherwise, I
> guess I'll just read the tables for each database and build the
> security script from that.
Roles are not per-database; they are
use pg_dumpall -g
On Fri, Oct 3, 2008 at 1:35 PM, Alvaro Herrera
<[EMAIL PROTECTED]>wrote:
> Julie Warden wrote:
>
> > Is there a method to dump just the roles from a database, or otherwise
> > select them, so I can build a script to reload the roles? Otherwise, I
> > guess I'll just read the tab
Is there a method to dump just the roles from a database, or otherwise
select them, so I can build a script to reload the roles? Otherwise, I
guess I'll just read the tables for each database and build the
security script from that.
from man pg_dumpall:
-r
--roles-only
Dump o
We would like to log sql activity from our web pages that use postgresql
databases.
I read the documentation for 8.1 at postgresql.org. The postgresql.conf file
under the -Where to log- section has
#log_destination = 'stderr'
Is stderr the default or do I need to remove the comment symbol to actu
