It would really be nice if pg_class were altered to add two new columns:
relcreatedat & relmoddat.
Both would be of type timestamp. relcreatedat would contain the timestamp the
object was created. Likewise, relmoddat would contain the last timestamp the
object was altered / modified.
This would
Oliveiros wrote:
> To start it, I have to login as postgres and manually start it with
> postgres -D etc.
You should make a backup first (users and databases ...) .
Try unregistering/registering the service with pg_ctl.
First copy the pg_ctl command used during installation from the
service's pro
VACUUM ANALYZE, rather
On Thu, Aug 20, 2009 at 2:21 PM, bricklen wrote:
> Did you vacuum your table after the delete?
>
>
> On Thu, Aug 20, 2009 at 2:36 AM, Kumar Anand
> wrote:
>
>> Dear all,
>>
>> I face this problem from last few days.
>>
>> here is test2 table with only one column id
>> er
Did you vacuum your table after the delete?
On Thu, Aug 20, 2009 at 2:36 AM, Kumar Anand wrote:
> Dear all,
>
> I face this problem from last few days.
>
> here is test2 table with only one column id
> erp_test=> \d test2
>Table "public.test2"
> Column | Type | Modifiers
> +--
Dear all,
I face this problem from last few days.
here is test2 table with only one column id
erp_test=> \d test2
Table "public.test2"
Column | Type | Modifiers
+-+---
id | integer |
I insert 10,000,000 entries in this table.
erp_test=> INSERT INTO test2 VALU
Many thanks!
Tena Sakai
-Original Message-
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Thu 8/20/2009 10:58 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Sharing /etc/passwd with PostgreSQL
On Thu, Aug 20, 2009 at 10:31 AM, Tena Sakai wrote:
On Thu, Aug 20, 2009 at 10:31 AM, Tena Sakai wrote:
> Can somebody please tell me how I could retrieve a
> history of this particular thread?
Generally:
http://archives.postgresql.org/
Specifically:
http://archives.postgresql.org/pgsql-admin/2009-08/msg00056.php
--
Regards,
Richard Broersma
On Thu, 2009-08-20 at 10:31 -0700, Tena Sakai wrote:
> Hi Everybody,
>
> I am interested in following this particular thread,
> though, yesterday our mail server went down for a few
> hours and I don't have the whole account.
>
> Can somebody please tell me how I could retrieve a
> history of thi
Hi Everybody,
I am interested in following this particular thread,
though, yesterday our mail server went down for a few
hours and I don't have the whole account.
Can somebody please tell me how I could retrieve a
history of this particular thread?
Thank you in advance
Regards,
Tena Sakai
tsa.
> When recover a database using a continuous archive backup, i detected some
> duplicated keys. This there isn't in the production database.
> I use postgres-8.3.5.
> anyone know why this happens?
>
What about the indexes in the slave?
--
Emanuel Calvo Franco
DBA at:
Alvaro Herrera writes:
> It had to do with me having a bogus password in .pgpass (so psql was
> first trying empty password, then the one in .pgpass, and both failing).
> Pilot error. However, I'd say that we ought to give a notice if the
> password in .pgpass fails.
Can we do something like
Tom Lane wrote:
> Alvaro Herrera writes:
> > BTW I notice that this does not work unless the client supplies the
> > password the first time around; psql does not retry. It only works if I
> > do "psql -W".
>
> Huh, that sounds like a bug someplace. Care to trace through it?
It had to do with
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
"Jan-Peter Seifert" writes:
> I didn't see any explicit type cast in 8.3 for regprocedure -> text. Is there
> a way to add it in 8.2?
You can always cast pretty much anything to anything via a variable
assignment in plpgsql...
regards, tom lane
--
Sent via pgsql-admin
Jan-Peter Seifert wrote:
> Hello,
>
> for dropping all functions within the current schema I use this SQL query:
>
> SELECT DISTINCT 'DROP FUNCTION ' || p.oid::regprocedure::text || ' CASCADE;'
> FROM pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
> p.pronamespace WHERE n.
First one, try to paste explain into http://explain.depesz.com/
> select
> a.id,
> ident_id,
> time,
> customer_name,
> extract('day' from timezone(e.name, to_timestamp(a.time))) as day,
> category_id
> from
> pwreport.url_hits a left outer join
> pwreport.url_hits_category_jt c on (a.id = c.url_h
Dear List,
This is my first post, I hope I am asking it on the correct list.
I changed the password for user postgres and I completely forgot about the
previous one.
The main problem is that now the postgres server fails to start when I turn
on the machine.
It used to start automatically.
To s
Hello,
for dropping all functions within the current schema I use this SQL query:
SELECT DISTINCT 'DROP FUNCTION ' || p.oid::regprocedure::text || ' CASCADE;'
FROM pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
p.pronamespace WHERE n.nspname = current_schema();
It works f
19 matches
Mail list logo
