pg_start_backup will flush old transactions, thus you have full DB backup.
Unless you want them archived, no need to keep them
Regards,
Bohdan
On Mon, Sep 22, 2008 at 09:41:47AM +0200, Joey K. wrote:
> During week 2, after the base backup, can we remove week 1's base and WAL
> files?
--
Sent
Hello,
> If you just want to ship segments to a standby server on a timely basis,
> the setting to tune should be archive_timeout, no?
just curious, how would the stand-by DB process the segments?
Regards,
Bohdan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
On Thu, Jul 31, 2008 at 11:24:35AM +0200, Bohdan Linda wrote:
> /opt/postgres-8.3.3/bin/psql -h remote -p postgres
> psql: FATAL: the database system is starting up
>
I am attaching additional info. The /dev/null is understable, but what I
am worried is that if I query status of
Hello,
I am fiddling around with pgpool-II and online recovery. Recovery depends
on remote starting of a cluster. This means I need to ssh into a box,
start clustern (with PITR recovery) and terminate that ssh connection.
If I use the following script:
ssh -T remote "export LD_LIBRARY_PATH=/opt/
I have done some research recently and found on acceptable:
- DBdesigner4, which is depreceated and replaced by MySQL workbench. Is
OSS, but no linux version yet. Also has clunky pgsql support
- Aqua data studio (www.aquafold.com). It's java app which I am using for
some time already. Origin
On Mon, Jun 09, 2008 at 04:41:16PM +0200, Tom Lane wrote:
> 8.0 is incapable of reordering outer joins, which is likely the cause of
> your problem.
Thank you, will try.
Bohdan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
Hello,
I have noted one very strange thing which I would like to discuss with
you. I have noted that outer joins on nested views takes heavily longer
than the inner ones. Example:
REATE VIEW ports_view AS
SELECT
ports.pid,
nodes.nname
FROM
ports JOIN nodes ON nodes.nid = ports.pnod
On Mon, May 19, 2008 at 08:38:09PM +0200, Scott Marlowe wrote:
> OK. Assuming that the 50G is mostly dead space, there are a few
> possibilities that could be biting you here, but the most likely one
> is that your Free Space Map settings aren't high enough to include all
> the rows that have been
On Mon, May 19, 2008 at 04:59:42PM +0200, Harald Armin Massa wrote:
> do not vacuum DAILY. set up autovacuum to run AT LEAST every minute.
> autovacuum will flag the "deleted" rows as to be reusable by next
> insert. Make sure to use 8.3., it's much more easy to setup
> autovacuum then before.
Hel
Hello,
I would like to ask an opinion on vacuuming general. Imagine situation
that you have single table with 5 fields (one varchar). This table has
during the day
- cca 620 000 inserts
- 0 updates
- cca 620 000 deletes
The table is vacuumed daily, but somehow after several months I got to
size
Hello,
thank you everyone for the answers. I went through and I forgot add one
thing. The web-app is frontend, thus basically PL/PGSQL launcher and all
changes are audited, so common login is unwelcome.
On Thu, May 15, 2008 at 05:40:49PM +0200, Steve Manes wrote:
> I keep the user's login crede
Hello,
I have the following problem. A multiuser app has authentization and
authorization done based on pgsql.
The frontend is web based so it is stateless; it is connecting to database
on every get/post. There is also a requirement that the user is
transparently logged in for some period of time
Hello,
Can the PGSQL database be configured that it performs authentication
against PAM and if fails the it tries against internal mechanizm?
I would like to migrate to PAM, but I do not want to promote some users to
system wide.
Till now I am able to do one or the other way.
Thank you,
Bohdan
Hello,
with help of Bricklen, I have found that the problem is the scope of call
EXECUTE. When this is called it seems to be "launched" outside of the trigger's
scope and OLD/NEW is not defined. (Manual suggests it)
The remaining question is how to compare OLD.* and NEW.* in generic way for
8.
Hello,
I am restricted to 8.0.7 version of postgresql and I am facing two problems
when trying to build generic auditing function. I went through documentation
http://www.postgresql.org/docs/8.0/interactive/plpgsql-trigger.html
example:
Example 35-3. A PL/pgSQL Trigger Procedure For Auditing
h
On Mon, Jun 04, 2007 at 04:21:32PM +0200, Chander Ganesan wrote:
> I think you'll typically find that you can get one or the other -
> synchronous replication, or load balancing...but not both. On the other
Hi,
I am in very similar position, but I am more failover oriented. I am
considering us
On Friday 17 March 2006 10:20 pm, Michael Glaesemann wrote:
> I've been having some email problems, so my apologies if this is a
> duplicate.
>
> On Mar 16, 2006, at 22:49 , Linda wrote:
>
>
> > Thanks for your reply. I guess you missed the original email. I
On Wednesday 15 March 2006 8:13 pm, Tom Lane wrote:
> Michael Glaesemann <[EMAIL PROTECTED]> writes:
> > On Mar 15, 2006, at 23:39 , Linda wrote:
> >> According to the SQL standard, shouldn't this work?
> >>
> >> select '506:47:04'::inter
nding questions to a
> PostgreSQL mailing list. By emailing me directly you may not get a
> timely response if I don't have time to answer. Others can then
> answer and learn from the subsequent discussion. I'm ccing this to
> pgsql-general.
>
> On Mar 15, 2
Hello,
I am sorry for this little offtopic, but recently I was looking for some
matured DB frontend. I am licensed user of Aquafold Datastudio and before
I will start to spend another money for next licenses, I would like to ask
you if there are some similar frontends out there, but with three
res
Thank you for the explanation.
Cheers,
Bohdan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mai
Hello all,
I would like to use password authentication for pgsql users for remote
backup purposes. I don't like the fact storing cleartext password on a
system. From documentation, i have learnt that passwords can be encrypted
by md5 and crypt methods.
But we know, that md5 is rather weak encryp
On Thu, Oct 06, 2005 at 11:57:32AM +0200, Martijn van Oosterhout wrote:
> This is the bit that's been bugging me this whole thread. Who owns the
> data? I've had to help people out with programs where they could type
> data in but couldn't get the reports they wanted out. Furtunatly,
> Access's acc
> No. Why? Describe your problem.
>
I have got response like bellow, when connecting to server in completely
different network than 172.x.x.x
--
org.postgresql.util.PSQLException: Connection rejected: FATAL: no
pg_hba.conf entry for host "172.x.x.x", user "XxXxXx", database
"yYyYyY",
Hello,
may I ask, how(or which) ip is checked against pg_hba.conf IP entry in NAT
environment?
Could it be, that psql client packs IP address of the client into athentication
data?
Regards,
Bohdan
---(end of broadcast)---
TIP 5: don't forget to
On Thu, Sep 08, 2005 at 04:35:51PM +0200, Michael Fuhr wrote:
> On Thu, Sep 08, 2005 at 03:39:50PM +0200, Bohdan Linda wrote:
> commit it now." You have to do some extra bookkeeping and you can't
> commit several prepared transactions atomically (as far as I know),
> but th
On Thu, Sep 08, 2005 at 02:53:47PM +0200, Michael Fuhr wrote:
> One way would be to use contrib/dblink to open another connection
> to the database so the status messages could be inserted in a
> separate transaction.
This could do the trick for logging, even writting of a package that would
do al
Tanks guys,
That was exactly what I was looking for.
B.
--- Begin Message ---
On 8/9/05 11:08 am, "Bohdan Linda" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I started thinking of some security access management. Basically imagine
> this scenario according users:
>
Hello,
I have read that 7.x version had a model "all or nothing" in transactions.
Thus I have upgraded to version 8 and would like to do the following:
plpgsq code does time intensive data manipulation + database vacuuming.
This data manipulation is splitted logically into several steps. After
Hi,
I started thinking of some security access management. Basically imagine
this scenario according users:
1) Writer does only inserts to black hole.
2) Reader does only reports on inserted data, cannot modify or add
anything
3) Maintainer can run a task on the data, but cannot read or add
Hello,
I have encountered on (for me) wierd thing. When dropping an user, the
database will not forget his permissions. After his recreation he has the
original permissions.
I use an approach of dropping all users when recreating the database
environment and user recreation to avoid any unwanted
>
> From the postgresql manual
> http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
> " The standard form of VACUUM is best used with the goal of maintaining
> a fairly level steady-state usage of disk space. If you need to return
> disk space to the operating system you can use
On Tue, Aug 30, 2005 at 06:07:24PM +0200, Michael Fuhr wrote:
> tables, and a VACUUM might start or complete immediately after you
> issue the query but before you read the results). This method is
> therefore unreliable.
I intend to do the VACUUM FULL during quiet hours, thus the chance of
fitti
Hello,
Is there any way how to detect running command VACUUM by reading pg_* tables?
The idea is to detectect when table is not accessible due maintainance. The
approach of explicitely setting a flag into status table is not very
convenient, while I want to cover also non-systematic launching
I would have a slight offtopic question, this is issue only of pgsql or
there are some other db solutions which have good performance when doing
this kind of replication across the world.
Regards,
Bohdan
On Thu, Aug 25, 2005 at 09:01:49AM +0200, William Yu wrote:
> It provides pseudo relief if
35 matches
Mail list logo
