On Dec 9, 2006, at 6:39 AM, Rajesh Kumar Mallah wrote:
Will it be a good feature to have pg_ctl check the syntaxes of
the config files before sending a SIGHUP to postmaster ?
Suppose a DBA does somes typos in the files, he shall be confused
not to see the changes in server even after pg_ctl relo
On Dec 9, 2006, at 6:19 PM, Philippe Salama wrote:
The textbook wanted me to create-db -U neil bpsimple, but I
accidentally created it as postgres. I want to follow directions
so future exercises will work ok.
It has taken me a while to figure out that there are , in bin,
programs such a
So did the script with those inserts report any errors?
On Dec 9, 2006, at 4:23 PM, Philippe Salama wrote:
and yet, the script I ran clearly has inserts of data to the
tables. And there was no indication that something failed when I
ran the script
Here is an excerpt from the script file
He estado leyendo sobre la configuracion de postgresql, pero tengo un
servidor que no me da el rendimiento que deveria de dar, lo monitoreo con
top, ps y pg_stat_activity y para lo que esta haciendo no deberia de ponerse
tan lento a como se pone, las tablas estan bien indexadas y se realizan
"Sandy Spence" <[EMAIL PROTECTED]> writes:
> select typowner from pg_type where typname='trigger';
> typowner
> --
> (0 rows)
Um ... what PG version is this exactly? ("select version()" if you're
not sure.)
It's real hard to see why pg_dump would complain about a type that's not
there
On 12/22/06, Sandy Spence <[EMAIL PROTECTED]> wrote:
Hi Rajesh,
I ran the select query
SELECT typowner from pg_type where typname='trigger';
In my installation \dT reports the type trigger
does it do so in yours? If it does not i am afraid
someone else shall be able to help you better.
regd
On 12/21/06, Joseph McClintock <[EMAIL PROTECTED]> wrote:
Thanks for the feed back. Doubling the work_men from 10240 to 20480
seemed to make the process faster but then I ran out of disk space.
Shared buffers are at 2000 which I can try increasing.
I now need to move the database off the system
Hi Rajesh,
I ran the select query
SELECT typowner from pg_type where typname='trigger';
with the following results
select typowner from pg_type where typname='trigger';
typowner
--
(0 rows)
I then ran the second select query
SELECT * from pg_user; (I also changed slightly select use
