Hi,
I am making backups using pg_dump, but if I have a need to restore one, I can
destroydb, then
createdb, then use psql -e < backup; but the permisson table for this
database isn't
restored (all GRANTs are loose).
Is there any way to force pg_dump to save also the permissions table?
s
Hi--
I, too, am new to psql. However, we did manage to get postgreSQL
version 6.3.2 running on an Indigo2, running Irix 6.2. It required using
gmake and flex instead of make and lex. Otherwise, we pretty much
followed the instructions in the documentation, and didn't have any
problems. Unfortuna
> On Thu, 1 Oct 1998, Bruce Momjian wrote:
>
> > > > > Has anyone tried running multiple postmasters w/ the same data
> > > > > directory.
> > > > > Any issues to watch out for? Problems with locking?
> > > > > All of the systems would be running on Red Hat 5.1 x86.
> > > >
> > > > Hard to im
> > > > Has anyone tried running multiple postmasters w/ the same data
> > > > directory.
> > > > Any issues to watch out for? Problems with locking?
> > > > All of the systems would be running on Red Hat 5.1 x86.
> > >
> > > Hard to imagine why you would want to do that. pg_log would be
> sh
On Thu, 1 Oct 1998, Bruce Momjian wrote:
> > > > Has anyone tried running multiple postmasters w/ the same data
> > > > directory.
> > > > Any issues to watch out for? Problems with locking?
> > > > All of the systems would be running on Red Hat 5.1 x86.
> > >
> > > Hard to imagine why you wo
Postmaster is multi-proccess server. i don't know why you would like to run
multiple postmaster. it might make sence if you wanto run different userid for
postmaster but still you can use pg_hda.conf file to control user access; therefore,
in my opinion, I don't think it's good idea to run
