forums and
documentation the only case described is accessing the pgbouncer database
on the localhost.
Thanks for any advice or hints,
Gaby
2014-08-27 11:03 GMT+02:00 Gabriele Lohss :
> Hi,
>
> thanks, you're right. My description wasn't very concrete. Our current set
> u
Hi,
thanks, you're right. My description wasn't very concrete. Our current set
up is a single pgbouncer instance running on a VM in the same network like
the webapplications. The database servers are in another firewall protected
network. So the pgbouncer is now running on a standalone VM. I was
w
Hi,
I'd like to use pgbouncer as connection pooler in our productive
environment, which consists of six master db server plus 6 slaves and many
webserver and services. For example, I'd like to use it as a central point
from where I can redirect client connections easily without changing the
code o
I second Bruce. I massively use asciidoc. I guess adding both asciidoc and
md would not be too hard.
Thanks,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
2014-02-12 6:02 GMT+01:00 Pavel
get will be included in the recovered server.
For further information, I suggest you look at:
http://www.postgresql.org/docs/9.2/static/recovery-target-settings.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@
ng it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
,
Gabriele
On Wed, 13 Mar 2013 09:48:19 +0100, Paolo Grifa
wrote:
Hi all,
I am quite new in postgres, having experience with Oracle.
I was trying to migrate some very simple applications from Oracle and
found out that some functions like TRUNC() are only available via an
addon called "orafce&
ould update the commitfest.postgresql.org website. For now, I have
updated that for you and the patch now reports you as a reviewer and
links the message to the patch. Here it is:
https://commitfest.postgresql.org/action/patch_view?id=900
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
Post
eally much appreciated.
Cheers,
Gabriel
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Array-ELEMENT-foreign-key-v1-refreshed.patch.bz2 | patch -p1
Then regular configure and make procedures
(http://www.postgresql.org/docs/current/interactive/install-procedure.html)
Useful link too: http://wiki.postgresql.org/wiki/Developer_FAQ
Hope this helps.
Thanks,
Gabriele
--
Gabriele
r and give
feedback.
Thank you.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
;
schema.
Please let me have more information if my assumption were wrong.
Cheers,
Gabriele
Tip/Note: by default, search_path is set to search in the "$user" and
public schemas. Therefore, if you connect using the "system_data" user,
you do not need to force searching
s you more flexibility and allows you to
change a tool for a specific component in the future without changing
the whole architecture.
Of course, I take it for granted that you have already thought about
the data warehouse layer (in case you have one).
Cheers,
Gabriele
--
Gabriele
seful
to manage very large data sets.
What you are looking for is called 'partitioning' (horizontal
partitioning). I suggest that you read this chapter:
http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
Post
list of objects for pg_dump.
It may sound unrelated at first, but if you have PostgreSQL 9.1 this use
case matches very well with the new EXTENSION framework. Please look at
the CREATE EXTENSION command and evaluate it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL
tion).
I suggest that you look at the -l and -L options in pg_restore, which
allow you to select which dump entries to restore (selective restore).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQ
Hi Toby,
Il 29/03/12 10:46, Gabriele Bartolini ha scritto:
Currently, there's no such a function. In general we simply check if a
'backup_label' file exists in PGDATA. However, it could be a good idea
to add it as admin function (I will have a think about it and possibly
come
idea
to add it as admin function (I will have a think about it and possibly
come up with a patch).
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mail
I could help you more here, but most of our professional work is
performed under strict NDAs.
An interesting and useful documentation section is this also:
http://www.postgresql.org/docs/9.1/interactive/high-availability.html
I hope this helps.
Cheers,
Gabriele
--
Gabriele Bartolini
On Thu, 15 Dec 2011 11:41:07 -0500, Carlos Mennens
wrote:
carlos@db1:~$ psql -c "SELECT pg_start_backup('label', true)"
psql: FATAL: database "carlos" does not exist
I forgot. You can also look at this:
http://www.postgresql.org/docs/9.1/static/app-pgba
it implied that I need to add 'postgres'
maintenance database in there or something else?
If the user carlos in your database has replication privileges, you can
try and execute the commands by connecting to the postgres database (if
your pg_hba.conf file allows you to do that, but t
mainly in terms of
inserts/updates/deletes.
I would gradually try and increase checkpoint_segments by 32 and
monitor the effects.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
-
ilability and Replication conference.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
writing
(http://projects.2ndquadrant.com/repmgr) which should make this kind of
things much easier for you.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql
Ciao Leonardo,
I am not sure if this could apply to your case, but maybe - unless you
have done it before - you could look at windowing functions
(http://www.postgresql.org/docs/current/interactive/tutorial-window.html).
They require PG8.4+ though.
Cheers,
Gabriele
On Wed, 4 May 2011 11
/support/professional_support) and let them do
the job for you. Probably cheaper and safer.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql
understood your request. Thanks.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
from record_table r where r.id > 2;
Have a look on the documentation about this kind of issues, which has
been improved from version 9
(http://www.postgresql.org/docs/9.0/interactive/plpgsql-implementation.html#PLPGSQL-VAR-SUBST).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Ita
-2010-td3288085.html
[1]
http://archives.postgresql.org/pgsql-hackers/2010-12/msg00087.php [2]
I totally missed this. Thanks for posting it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuad
on High Performance (which you can find from here:
http://www.postgresql.org/docs/books/)
Merry Christmas to you too!
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent vi
always a good thing.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
Thanx guys, all of your solutions are fine, but I could manage it in a
different manner.
Modified the ident map file to map my special system user to postgres, so I
don't have to
specify the postgres user any more ;)
Thanx!
Gabriele.
-= Mail sent through We
Hi Gabriele,
I forgot to mention one thing.
> That means that PostgreSQL is successfully running. Try and connect to
the
> database using a different user by passing the '-U' option to psql or by
> setting the PGUSER environment variable.
PostgreSQL creates a role/user
Hi Gabriele,
On Wed, 3 Nov 2010 11:29:25 +0100 (CET), Gabriele Bulfon
wrote:
> I need to run postgres under the same user/group, witout having to
create
> and use postgres user.
That's reasonable and perfectly doable with Postgres.
> But now I can't seem to connect to the d
can't seem to connect to the database, because it says:
FATAL: role "postgres" does not exist
How can I let postgres run under my own user instead of postgres?
I can rebuild from sources, if needed.
Thanx,
Gabriele.
-= Mail sent through WebTop2 =-
Il 30/10/10 10:52, RP Khare ha scritto:
I want pgsql to take automatic scheduled backup of the database every
30 minutes. How to do this?
On Unix like systems, you can set a crontab that executes pg_dump every
30 minutes.
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training
never replied to that.
Next time, please post the version you are using and possibly the
operating system.
> It's incredible, DB don't change dimension even after 1 million insert
and
> update.
> CPUs average load drastically is fallen down!
Glad you fixed it.
Ciao
).
It seems a bug
It is definitely not a bug, but a desired behaviour deriving from the
MVCC architecture.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general
Hi,
Il 26/10/10 23:01, Hfe80 ha scritto:
Some one know how to solve the problem of db that became huge from 700 Mbyte
to 16 Gbyte in 10 days and grow...
Which version of PostgreSQL are you using?
Some one Know this problem?
Yes. Welcome to the "Bloating" club. :)
Ciao
Hi Alex,
Of course "select ... into" doesn't work, but how should I do it?
Can't find in http://www.postgresql.org/docs/8.1/static/
You might want to look at the CREATE TABLE AS command. You might even
use the temporary definer.
Ciao,
Gabriele
--
Gabriele Bartolini
is the possibility to
build a sync between a 32 and a 64 bit (on linux)?
As stated in the documentation
(http://www.postgresql.org/docs/9.0/static/warm-standby.html), the
hardware architecture must be the same.
Hope this helps.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
Post
> Sounds like something you'd want to handle within the application
I believe i will try to follow this path.
---(end of broadcast)---
TIP 6: explain analyze is your friend
I know this is a delicate topic which must be approached cautiously.
Let's have a server which feed data to multiple slaves, usually using
direct online connections. Now, we may want to allow those client to
sync the data to a local replica, work offline and then resync the
data back to the server
I need a design tool to design my database.
Back in past I used DBDesigner (free) but it is best suited to MySQL
and i now use PostGreSQL and SQLite.
The tool should have most of the following:
Ability to create a rather complex and arbitrarily big scheme and
produce automatically the SQL code f
On 14 Giu, 12:38, [EMAIL PROTECTED] (Marco Colombo) wrote:
> While PG has tons more features than SQLite, the major question here is:
> do you really need a database _server_? One thing that PG is designed
> for is handling many (as in 100) concurrent users. Database users, that
> is, meaning proc
I will probably try PostGreSQL for my needs as it seem powerful enough
and easy to ship to my potential customers.
For the data provider i will try npgsql as you and others suggested,
as it seem enough reliable and stable to be used efficiently.
I will probably use newsgroups again later if and wh
I'm going to develop a medium sized business desktop client server
application which will be deployed mostly on small sized networks and
later eventually, hopefully, on medium sized networks.
It will probably be developed using C#.
I do need a solid DBMS wich can work with .Net framework. I do kno
Hi.I'm using postgresql 8.0.3 under win2000 and developing with VS2003
(npgsql net provider).I would like to start a transaction with a sql
function.When user press "edit" button on my form, i would lock the current
row.After user has modified data on form, pressing "save" button I would
sa
stance the record with, let's say, age between 10 and 20
on a specific cluster, from 20 to 30 on another one, and so on?
Thank you
-Gabriele
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
s
49 matches
Mail list logo
