On Fri, 16 May 2008 15:12:02 -0600
kevin kempter <[EMAIL PROTECTED]> wrote:
> Hi List;
>
> Can I install a PL/pgSQL function so it's global to all databases
> within a cluster or do I need to install per database ?
>
Install it into template1 then each database created after that will
have th
Hi List;
Can I install a PL/pgSQL function so it's global to all databases
within a cluster or do I need to install per database ?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgs
You can also go into the pg_hba.conf file, and at the bottom put a #
sign in front of host and then instead of the method set to 'md5', put
'trust'. This will allow you to login without a password, and then you
can reset it.
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED
On Fri, May 16, 2008 at 11:50 AM, Roberto Edwins
<[EMAIL PROTECTED]> wrote:
> What are the values that should go in postgresql.conf for a larga
> database, a couple of which tables shall contain over 100 million
> records?
Well, that really kind of depends. Is this a database to handle lots
of us
On Fri, May 16, 2008 at 11:53 AM, LaRue, Patricia
<[EMAIL PROTECTED]> wrote:
> Thank you Jeff and Scott:
>
> I found this on the archives.postgresql.org site and it worked. I
> wanted to post it in case someone else has the same problem.
>
> First go to start>>settings>>control panel>>user account
Thank you Jeff and Scott:
I found this on the archives.postgresql.org site and it worked. I
wanted to post it in case someone else has the same problem.
First go to start>>settings>>control panel>>user account>> select
advanced tab, click advanced button>>then click user folder and delete
the po
What are the values that should go in postgresql.conf for a larga
database, a couple of which tables shall contain over 100 million
records?
Thanks in advance.
- Roberto
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresq
On Fri, 2008-05-16 at 13:21 -0400, Mark Steben wrote:
> Simon, I think you uncovered the problem but I don't see anyway around
> it Short of reloading the db from a pg_dump backup. Any suggestions
> would Be appreciated. Thanks,
Re-run the backup? Sounds safest.
--
Simon Riggs www.
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
[EMAIL PROTECTED]
Visit our new website at
www.autorevenue.com
IMPORTANT: The information contained in this
On Fri, 16 May 2008, LaRue, Patricia wrote:
I installed PostgreSQL and created the initial "very long" password and
wrote it down. Someone else did something to change it and now neither
one of us can log into the DB. So I tried to uninstall and reinstall
but my "very long" password is not rec
On Fri, May 16, 2008 at 8:41 AM, LaRue, Patricia
<[EMAIL PROTECTED]> wrote:
> Experts:
>
>
>
> I installed PostgreSQL and created the initial "very long" password and
> wrote it down. Someone else did something to change it and now neither one
> of us can log into the DB. So I tried to uninstall
Hi chaps,
I was just wondering if anyone has any clever way of testing their backups
taken with pg_dump on a daily basis?
On a slightly separate note,
I've setup a daily restore onto a staging server that I intend to also use to
test the dumps, at the moment I've just set up a cron job. I'm su
Experts:
I installed PostgreSQL and created the initial "very long" password and
wrote it down. Someone else did something to change it and now neither
one of us can log into the DB. So I tried to uninstall and reinstall
but my "very long" password is not recognized and without it I cannot
co
On Fri, 2008-05-16 at 11:35 -0400, Mark Steben wrote:
> I’m in the process of implementing PITR backups and restores and
> learning as I practice. I restored
>
> Using tar –xzf (backup-name) followed by restarting postgres and
> having the server replay the logs.
>
> I used a recovery_tar
Hi folks,
I'm in the process of implementing PITR backups and restores and learning
as I practice. I restored
Using tar -xzf (backup-name) followed by restarting postgres and having
the server replay the logs.
I used a recovery_target_time of 1 day prior to current_date Postgres
seems to
15 matches
Mail list logo
