Keith C. Perry writes:
> What am I missing?
A reproduceable test case.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Keith C. Perry writes:
>
> > What am I missing?
>
> A reproduceable test case.
>
> --
> Peter Eisentraut [EMAIL PROTECTED]
>
???
Ok, lets try the question this way...
What is a method of dumping and restoring a complete database cluster whe
I was going a test run through of of moving my 7.1.3 databases to 7.4RC1 and I
have a problem with creating databases for my users that do not have
administrative accounts. By that I mean, these users are NOT allow to create
databases. So the process was this:
On the 7.1.3 server:
pg_dumpall -c
On Sat, Nov 15, 2003 at 11:31:08PM -0500, Bruce Momjian wrote:
> > I might be wrong on this but I think that ecpg using transactions by
> > default for each query.
> > Perhaps turning on autocommit?
>
> Yep, use:
>
> EXEC SQL SET AUTOCOMMIT = ON;
Or use 'ecpg -t'.
Michael
--
Michael Mes
"Keith C. Perry" <[EMAIL PROTECTED]> writes:
> On the 7.1.3 server:
> pg_dumpall -c > dump.db
You would probably have better luck using the 7.4 installation's pg_dump
and pg_dumpall to extract data from the 7.1 server; there are three
releases worth of bug-fixes in those that are not in the 7.1 du
Keith C. Perry writes:
> What is a method of dumping and restoring a complete database cluster when that
> cluster contains users that are NOT allowed to create databases.
There is nothing special you need to do, except of course not actually
restoring the dump as one of those unprivileged users.
If the database is running it will tell you when you log into it with psql.
bpalmer wrote:
I'm trying to figure out what version of a source code I have. I know
it's a 7.2 release, but how can I find out of it's 7.2, 7.2.3, 7.2.4,
etc. FROM THE SOURCE CODE, not from compiling (it doesn't
Martin Marques <[EMAIL PROTECTED]> writes:
> El Vie 14 Nov 2003 12:37, Tom Lane escribió:
>> Hmm. If it got that far and no farther, I'd guess you have SEMVMX
>> set too small.
> Is there a way of changing this value on Linux without recompiling?
See sysctl. But what is the current value? I'v
El Vie 14 Nov 2003 12:37, Tom Lane escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > creating template1 database in /usr/local/pgsql/data/base/1... FATAL:
> > semctl(1638435, 16, SETVAL, 536) failed: Argumento inválido
>
> Hmm. If it got that far and no farther, I'd guess you have SEMV
El Dom 16 Nov 2003 15:23, Tom Lane escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > El Vie 14 Nov 2003 12:37, Tom Lane escribió:
> >> Hmm. If it got that far and no farther, I'd guess you have SEMVMX
> >> set too small.
>
> > Is there a way of changing this value on Linux without recomp
On Sun, Nov 16, 2003 at 10:47:22AM -0800, Joshua D. Drake wrote:
>
> >Whoa! You mean these aren't already separate database clusters or
> >even separate systems? I am very shocked, you can't do a proper Dev
> >--> QAT --> Prod environment if all three systems are run by the same
> >postmaster, or
Whoa! You mean these aren't already separate database clusters or even separate
systems? I am very shocked, you can't do a proper Dev --> QAT --> Prod
environment if all three systems are run by the same postmaster, or on the same
host imo. But maybe I'm just over cautious, or worked on systems wh
What am I missing?
A reproduceable test case.
It is reproduceable for him Peter.
Keith could you provide a little more information?
Who is the user doing the dump?
Who is the user doing the restore?
Are these users superusers?
Either way, my suggestion would be to dump the schema on
El Dom 16 Nov 2003 16:56, escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > El Dom 16 Nov 2003 15:23, Tom Lane escribió:
> >> See sysctl. But what is the current value? I've never heard of a Linux
> >> installation with small SEMVMX.
>
> > [EMAIL PROTECTED]:~/latex$ cat /proc/sys/kernel
Martin Marques <[EMAIL PROTECTED]> writes:
> El Dom 16 Nov 2003 15:23, Tom Lane escribió:
>> See sysctl. But what is the current value? I've never heard of a Linux
>> installation with small SEMVMX.
> [EMAIL PROTECTED]:~/latex$ cat /proc/sys/kernel/sem
> 250 32000 32 128
> This is a
15 matches
Mail list logo
