>
> As you may have noticed, I've put significant effort to focus the
> discussion on my actual question: the "global index" (which btw I didn't
> know is called this way here - if I new, I'd probably could have google
> it instead). This was intentional. I like my schema design very much and
> I'
> On Sep 16, 2017, at 11:18 AM, Rafal Pietrak wrote:
>
> Dear robjsarg...@gmail.com,
>
> W dniu 16.09.2017 o 17:19, Gmail pisze:
>>
>>
>>> On Sep 16, 2017, at 8:23 AM, Rafal Pietrak wrote:
>>>
>>>
>>>
>>>
> On Sep 16, 2017, at 8:23 AM, Rafal Pietrak wrote:
>
>
>
> W dniu 16.09.2017 o 15:45, Adam Brusselback pisze:
>> Here is the last discussion I saw on
>> it:
>> https://www.postgresql.org/message-id/flat/90261791-b731-a516-ab2a-dafb97df4464%40postgrespro.ru#90261791-b731-a516-ab2a-dafb97df4.
> On Jul 2, 2017, at 10:06 AM, Tom Lane wrote:
>
> twoflower writes:
>> I am having problems creating an Ispell-based text search dictionary for
>> Czech language.
>
>> Issuing the following command:
>
>> create text search dictionary czech_ispell (
>> template = ispell,
>> dictfile = czec
Sent from my iPad
> On Jul 2, 2017, at 10:06 AM, Tom Lane wrote:
>
> twoflower writes:
>> I am having problems creating an Ispell-based text search dictionary for
>> Czech language.
>
>> Issuing the following command:
>
>> create text search dictionary czech_ispell (
>> template = ispell,
Sent from my iPad
> On Feb 14, 2017, at 9:47 PM, Shawn Thomas wrote:
>
> No it doesn’t matter if run with sudo, postgres or even root. Debian
> actually wraps the command and executes some some initial scripts with
> different privileges but ends up making sure that Postgres ends up running
> On Dec 4, 2016, at 9:32 AM, Justin Pryzby wrote:
>
> Our application INSERTs data from external sources, and infrequently UPDATEs
> the previously-inserted data (currently, it first SELECTs to determine whether
> to UPDATE).
>
> I'm implementing unique indices to allow "upsert" (and pg_repack
Contact any of the professional support organizations and ask for whom they
work. Some will, some won't name names.
Sent from my iPad
> On Dec 3, 2016, at 5:41 PM, Michael Paquier wrote:
>
>> On Tue, Nov 29, 2016 at 10:25:50AM -0200, Saulo Tadeu wrote:
>> I'm would like to know which companie
I'm attempting to get a little bit more disk performance out of a data
warehouse like PG 9.5 RC1 instance I have that is running on ZFS
(recordsize=128K). When trying to make PG 9.5RC1 with --blocksize > 8 four of
the make check tests are reported as failing. I'm curious as to if this is a
pr
Sent from my iPad
> On Jun 3, 2015, at 7:50 AM, Adrian Stern wrote:
>
> Hi William, thanks for joining the conversation.
>
> 1) We do hope for constraints since a connection to an ERP system is possible
> in the future. We want to plan ahead.
>
> 2) As for the subclass approach: I would ne
Il 19/10/2012 16:45, Shaun Thomas ha scritto:
On 10/19/2012 09:38 AM, GMAIL wrote:
but if i connect from another pc, with pgadmin 1.16 or other software,
to the host with postgresql i get a "connection refused" message
Ok. That narrows it down slightly. If you check your PG logs
Il 19/10/2012 16:55, Shaun Thomas ha scritto:
Yep. You've got a firewall between you and your server. Somewhere.
Good luck tracking that down, sir. Everything should clear up when/if
that gets resolved.
i think that the problem should be the service iptables.
what i have to change if i want to
Il 19/10/2012 16:33, Shaun Thomas ha scritto:
If you don't get any error message from the client or the server, are
you sure it didn't work?
I only ask because 1.8 was so old, I'm surprised it even worked with
the version you had before. The catalog has changed a lot since then,
and the err
Il 19/10/2012 16:11, Shaun Thomas ha scritto:
On 10/19/2012 09:06 AM, GMAIL wrote:
i use postgresql 9.1 and pgadmin 1.8.4
Yeah, that version of pgAdmin is *way* too old. 1.16 was released
fairly recently, and it works great.
i try the version 1.16 but it doesn't work. i don'
Il 19/10/2012 15:40, Chris Ernst ha scritto:
On 10/19/2012 07:24 AM, GMAIL wrote:
Il 19/10/2012 15:24, Chris Ernst ha scritto:
On 10/19/2012 07:02 AM, GMAIL wrote:
I have 2 cluster databases, running on the same host, Ubuntu. My fist
database port is set to default but my second database port
postgresql 9.1 and pgadmin 1.8.4
And there it is. You'll need pgAdmin >= 1.12.x to work with PostgreSQL 9.1.
- Chris
can be a firewall problem?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/m
Il 19/10/2012 16:05, Chris Ernst ha scritto:
On 10/19/2012 07:50 AM, GMAIL wrote:
Il 19/10/2012 15:40, Chris Ernst ha scritto:
On 10/19/2012 07:24 AM, GMAIL wrote:
What happens when you try to connect? Any error message? Log entries?
- Chris
now i be able to connect, after update pgAdmin, but
Il 19/10/2012 15:40, Chris Ernst ha scritto:
On 10/19/2012 07:24 AM, GMAIL wrote:
What happens when you try to connect? Any error message? Log entries?
- Chris
now i be able to connect, after update pgAdmin, but i receive the
following error:
"ERROR: column "datconfig" does n
Il 19/10/2012 15:24, Chris Ernst ha scritto:
On 10/19/2012 07:02 AM, GMAIL wrote:
I have 2 cluster databases, running on the same host, Ubuntu. My fist
database port is set to default but my second database port is set to
5433 in the postgresql.conf file. While everything is ok with local
I have 2 cluster databases, running on the same host, Ubuntu. My fist
database port is set to default but my second database port is set to
5433 in the postgresql.conf file. While everything is ok with local
connections, I cannot connect using any of my tools to the second
database with port 54
i have created two cluster in the same host the first called "main" with
port 5432 the second called "remote" with port 5433.
but when i try to connect with pgadmin3 to the second cluster i get the
error "authentication failed".
if i try to connect to the first cluster i don't have any kind of p
it's possible to access the same data from two different servers. the
two servers have the same IP and not run simultaneously
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
i describe the situation:
i have two pc with postgressql server:
- a main pc, with ip 192.168.5.1 turned on
- a "backup" pc, with ip 192.168.5.1 turned off
i want that the main pc saves the database in local hard drive and on a
nas real-time. when the main pc has a failure, i turn on, manually,
Hello,
On Tue, 2010-06-22 at 04:50 -0700, Deven wrote:
> Hi all,
>
> I am using Postgresql Database for our system storage and I am running
> Autovacuuming Deamon on my entire database. But on of the table set in
my
> database never undergoes the Autovacuuming. I always need to do the
manual
> va
Hello guys,
thx for your inputs. I consider you suggestions valid.
We have hundreds or thousands of unreachable and unmaintained PG
instalations. I'm totally unable to experiment in each of them. Usage
profile can range from 100 rows per hour to 1000, 10.000, 50.000...
sustained... for several da
Hello all,
I need to write an application in C to read the list of databases
currently in the server. very much like a "psql -l"...
but I need it in C ! I never used C before to access PG.
the libpq API seems a bit scary ! Is there anything, shipped with
postgresql, other than libpq that would m
On Fri, 2010-03-05 at 10:03 -0500, akp geek wrote:
> Hi All -
>
> I am still having the issue, even after I turned on the
> auto vaccum. I have quick question. How do I know that auto vacuum
> process is running. When I restarted my database , I got the message
> auto vacuum launcher
On Wed, 2010-03-03 at 12:46 -0500, akp geek wrote:
> Hi All -
>
> I need some help from you. this question is in follow up
> with my earlier questions. I turned the autovacuum and restarted the
> db and the settings I have as follows. It seems the autovacuum process
> has not been turne
Hello,
Considering the CLUSTER operation on a frequently updated table, if I
have 2 indexes on the table how do I choose one of them ? or is it
possible to have CLUSTER take both into consideration...
my table is read from based on two columns: a 'timestamp' integer column
(actually a UTC integer
On Fri, 2010-02-12 at 18:43 +0100, Marcin Krol wrote:
> Amitabh Kant wrote:
> > You need to do VACUUM FULL ANALYZE to claim the disk space, but this
> > creates a exclusive lock on the tables.
> >
> > See http://www.postgresql.org/docs/8.3/static/sql-vacuum.html
>
> Aha!
>
> OK but why did the
On Wed, 2009-11-18 at 08:39 -0700, Scott Marlowe wrote:
> On Wed, Nov 18, 2009 at 8:12 AM, Joao Ferreira gmail
> wrote:
> > I'dd suggest:
> >
> > pgdumpall --clean > dump.sql
>
> I'd think he'd be much better off with pg_dump, not pg_dumpall.
yes
I'dd suggest:
pgdumpall --clean > dump.sql
edit the dump.sql file by hand replacing database name and owners and
so...
then reload into the new DB with psql -f dump.sql postgres
this does all the work except creation of users and databases
should give you an exact replica with all data inside
> A strange behaviour is observerd in the physical files with respect to
> this table. The size of the file is growing abnormally in GBs. Suppose
> the file name (oid of relation )with respect to the table is "18924" I
> could find entries of 1 GB files like 18924, 18924.1, 18924.2 ,
> 18924.3..
I was considering
rm
thx
Joao
On Sat, 2009-11-14 at 14:35 -0500, Bill Moran wrote:
> Joao Ferreira gmail wrote:
> >
> > Hello all,
> >
> > How can I safelly erase (with rm command in Linux) files or dirs
> > concerning a specific database ?
>
> What do yo
Hello all,
How can I safelly erase (with rm command in Linux) files or dirs
concerning a specific database ?
assuming I whish to elimiante data belonging to database A but I do not
whish to disturb or cause any injury to database B
Is there documentation on how to do this or on what exactly am I
On Thu, 2009-05-28 at 16:43 +0100, Grzegorz Jaśkiewicz wrote:
> On Thu, May 28, 2009 at 4:24 PM, wrote:
> > hi, sorry my english
> > I need to copy a data base from windows to linux, how can I save my data
> > base from windows with pg_dump, and where the file is??
> > and after how can I cre
On Wed, 2009-05-06 at 16:53 +0100, Joao Ferreira gmail wrote:
> hello,
>
> as a perl addict I am... I recommend checking this out:
>
> http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm
>
> it's pretty flexible and allows you to specify to some exte
hello,
as a perl addict I am... I recommend checking this out:
http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm
it's pretty flexible and allows you to specify to some extent just how
the database structure is infered from the XML...
check it out
Joao
On Wed, 2009-05-06
pg 8.1.4 has a very ugly bug which prevents VACUUM and AUTOVACUUM from
performing well
I certain situations the AUTOVACUUM will start failing and any VACUUM
operations will fail too.
solution I found was to periodically REINDEX my tables and INDEXES.
the major effect of this bug is Pg starts
On Wed, 2009-04-22 at 22:12 +0530, S Arvind wrote:
> Our company wants to move from 8,1 to 8.3 latest. In irc they told me
> to check realse notes for issues while upgrading. But there are lots
> of release notesss. Can anyone tell some most noticable change or
> place-of-error while upgrading?
on
On Sun, 2009-04-12 at 09:27 -0700, Irene Barg wrote:
> Hi,
>
> We are running postgresql-8.1.9 and plan to upgrade to 8.2 or even 8.3
> but can't just yet. I need to run analyze periodically (like hourly),
> but before I write a script to loop through the tables in each schema
> and run analyz
On Wed, 2009-01-28 at 09:09 -0800, David Miller wrote:
> Pg Dump does not include schema name on insert statement generated from
> pg_dump with a -d option when exporting data for a particular table using the
> -t . in version 8.3. I believe this same bug exists in 8.4 but
> have not confirmed i
On Tue, 2008-11-11 at 11:16 +, Richard Huxton wrote:
> Joao Ferreira gmail wrote:
> > hello all,
> >
> > I have 2 dumps of the same Pg database in diferent instants.
> >
> > I'dd like to merge the two dumps into one single dump in order to
> > res
hello all,
I have 2 dumps of the same Pg database in diferent instants.
I'dd like to merge the two dumps into one single dump in order to
restore all data at one time.
Is this possible ? are there any helper tools to aid in dealing with
text dump files ?
thanks
Joao
--
Sent via pgsql-gener
On Wed, 2008-11-05 at 15:08 -0600, Tony Fernandez wrote:
> Hello all,
>
>
>
> I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I
> also use Slony 1.2.14 for replication.
>
>
>
> Is there a safe path on how to accomplish this, please advice on what
> steps I will need to c
Hello,
I've been searching the docs on a simple way to convert a time
_duration_ in seconds to the format dd:hh:mm:ss, but I can't find it.
90061 --> 1d 1h 1m 1s
(90061=24*3600+3600+60+1)
any ideas ?
I've been using to_char and to_timestamp to format dates/timestamps...
but this is diferent...
On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote:
> On Thursday 30 October 2008, Joao Ferreira gmail
> <[EMAIL PROTECTED]> wrote:
> > What other cfg paramenters shoud I touch ?
>
> work_mem set to most of your free memory might help.
I've raised work_mem to
Hello all,
I've been tring to speed up the restore operation of my database without
success.
I have a 200MB dump file obtained with 'pg_dumpall --clean --oids'.
After restore is produces a database with one single table (1.000.000)
rows. I have also some indexes on that table. that's it.
It alwa
Hello Eduardo
On Tue, 2008-10-14 at 15:40 -0500, Eduardo Arévalo wrote:
> I installed the 8.3 postgres
> the amount of giving the command:
> bash-3.2$ /usr/local/postgres_8.3/bin/initdb -D /base/data
>
that command only initializes the underlying filesystem database files,
directories and conf
Hello all,
I have a ascii dump file based on the COPY operation.
lets say I restore this dump into a live database with applications
doing INSERTs and UPDATEs onto it.
in case the COPY of a register causes a primary key (or UNIQUE, or FK)
violation does the psql restore command try to continue t
Hello all,
I need to print to a file a simple list of all the databases on my
postgresql.
I need to do this from a shell script to be executed without human
intervention
I guess something like:
su postgres -c 'psql ...whatever > /tmp/my_databases.txt'
but I don't know exactly to what exten
thank you depesz
it seems a pretty good fix for my problem. Actually yestreday I came up
with something similar but your's is better.
cheers
joao
On Tue, 2008-09-23 at 09:26 +0200, hubert depesz lubaczewski wrote:
> On Mon, Sep 22, 2008 at 05:59:25PM +0100, Joao Ferreira gmail wrote:
well...
my IP addresses are stored in a TEXT type field. that field can actually
contain usernames like 'joao' or 'scott' and it can contain IP
addresses
:(
joao
On Mon, 2008-09-22 at 11:13 -0600, Scott Marlowe wrote:
> On Mon, Sep 22, 2008 at 10:59 AM, Joao F
hello all,
I'm unable to build a LIKE or SIMILAR TO expression for matching and ip
address
192.168.90.3
10.3.2.1
any help please...
thanks
joao
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgs
h is exactly my case.
any hints.
thx
j
On Sat, 2008-09-13 at 16:48 -0400, Robert Treat wrote:
> On Thursday 11 September 2008 07:47:00 Joao Ferreira gmail wrote:
> > Hello all,
> >
> > my application is coming to a point on which 'partitioning' seems to be
> >
Hello all,
my application is coming to a point on which 'partitioning' seems to be
the solution for many problems:
- query speed up
- data elimination speed up
I'dd like to get the feeling of it by talking to people who use
partitioning, in general..
- good, bad,
- hard to manage, easy to man
Is there a date for the release of 8.4 ?
joao
On Thu, 2008-09-04 at 10:09 -0400, Alvaro Herrera wrote:
> paul tilles wrote:
> > Where can I find a list of changes for Version 8.4 of postgres?
>
> It's not officially written anywhere. As a starting point you can look
> here:
> http://wiki.postgr
Hello all,
in which system tables can I find the effective run-time values of the
autovacuum configuration parameters...
naptime, thresholds, scale factors, etc
thx
joao
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
2008-08-28 at 11:27 -0400, Bill Moran wrote:
> In response to Joao Ferreira gmail <[EMAIL PROTECTED]>:
> >
> > On Thu, 2008-08-28 at 19:53 +0800, Phoenix Kiula wrote:
> > > On our database of about 5GB we vaccuum all of our 12 tables (only one
> > > is
On Thu, 2008-08-28 at 19:53 +0800, Phoenix Kiula wrote:
> On our database of about 5GB we vaccuum all of our 12 tables (only one
> is huge, all others have about 100,000 rows or so) every hour or so.
if you refer to manual VACUUM or VACUUM FULL every hour is probably too
much. You should aim your
Hello all,
I'm getting this error after installing pg-8.3.3 on a test system which
had 8.1.4
shell> su postgres -c "/usr/bin/postmaster -D /var/pgsql/data"
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 8.1,
which is not compa
> Any suggestions? Is my procedure correct? Would I need to also copy
> the transaction logs or something like that?
the 'by the book' procedure for this operation is to use
pg_dumpall . > dump_file.sql
and later
psql -f dump_file.sql postgres
pg_dumpall gives you a transaction
Hello all
While debugging my autovacuum I increased the level of logging to
"debug3" and got this:
# cat /var/pgsql/data/logfile | grep vac | egrep "mydb|mytable"
LOG: autovacuum: processing database "mydb"
DEBUG: mytbl: vac: 10409 (threshold 20), anl: -183366 (threshold
5)
LOG: auto
Hello all,
a few days ago I bumped into this:
-
# vacuumdb -f -z -a
vacuumdb: vacuuming database "postgres"
VACUUM
vacuumdb: vacuuming database "rtdata"
vacuumdb: vacuuming of database "rtdata" failed: ERROR: failed to
re-find parent key in "timeslots_s
> Because VACUUM FULL needs to move stuff around in the table which means it
> need to mess around with the indexes (adding new entries). Ordinary
> VACUUM only needs to delete stuff so doesn't cause anywhere near as
> many problems.
so in the event that I really end up running VACUUM FULL o
oao Ferreira gmail wrote:
> > On Mon, 2008-08-11 at 10:58 -0600, Scott Marlowe wrote:
> >
> > If I try cluster, I'm guessing I'll choose the big index and forget
> > about the smaller ones... is this right ?
> >
>
> CLUSTER will sort out all the ind
On Tue, 2008-08-12 at 11:53 -0400, Tom Lane wrote:
> TW, "more aggressive routine vacuuming" does NOT mean "use vacuum
> full".
> Vacuum full tends to make index bloat worse, not better.
>
> regards, tom lane
>
Ok. so what does it mean ?
I'm a bit lost here. I'm curre
Hello all
[[[ while dealing with a disk size problem I realised my REINDEX cron
script was not really being called every week :( so... ]]]
I executed REINDEX by hand and the disk ocupation imediatelly dropped 6
Giga...!!!
is there a way to configure postgres to automatically execute the needed
On Mon, 2008-08-11 at 10:58 -0600, Scott Marlowe wrote:
> It's likely you've got index bloat. If you reload a pg_dump of the
> database in question into another server how much space does that take
> up?
right. just loaded the dump into a clean database and everything came
down about 10 times.
On Mon, 2008-08-11 at 12:45 -0400, Greg Smith wrote:
> On Mon, 11 Aug 2008, Joao Ferreira gmail wrote:
>
> > I'm finding it very strange that my pg takes 9Giga on disk but
> > pg_dumpall produces a 250Mega dump. 'VACUUM FULL' was executed
> > yesterday.
ots_timeslot_index" btree (timeslot)
"timeslots_timestamp_index" btree ("timestamp")
"timeslots_var_index" btree (var)
egbert=#
On Mon, 2008-08-11 at 12:45 -0400, Greg Smith wrote:
> On Mon, 11 Aug 20
| 3993 kB
turba | 3673 kB
edgereporting | 3617 kB
template1 | 3617 kB
template0 | 3537 kB
(7 rows)
postgres=#
> V.
>
> Joao Ferreira gmail wrote:
> > Hello all,
> >
> > I'm finding it very strange that my pg takes 9Gig
Hello all,
I'm finding it very strange that my pg takes 9Giga on disk but
pg_dumpall produces a 250Mega dump. 'VACUUM FULL' was executed
yesterday.
Is this normal ? Should I be worried ?
details bellow:
Hello all,
could you please recommend tools to make diagnostic, admin and
maintenance work easier...
I imagine there are tools (maybe graphical, or browser based) that allow
me to connect to postgres and receive diagnostic data and
pointers/recommendations on how to solve specific problems or op
Hello all,
we are using PostgreSQL in a situation where I think we could try and
run two separate instances:
- 1 application can grow up to 10 Giga data; needs 'frequent' vaccuming
and re-indexing (lots of insert, updates and deletes, per minute): we
use it for 'near-real-time' applications logs
Il Wednesday 19 December 2007 22:29:25 Colin Wetherbee ha scritto:
> GMail wrote:
> > When trying to create an index on a composite type, I need to enclose
> > the columns in paranthesis. Is this normal?
> > I don't think so as there's no mention in the friendly manu
Hi all.
When trying to create an index on a composite type, I need to enclose
the columns in paranthesis. Is this normal?
I don't think so as there's no mention in the friendly manual.
An example:
create type atype as (
atext text,
anint int
);
create table atable (
info text,
compo aty
77 matches
Mail list logo
