On Wed, 2013-07-03 at 20:53 +0900, Ian Lawrence Barwick wrote:
> 2013/7/3 Jiří Hlinka :
> > Hi All,
> >
> > I have a 8.4 server and I'd like to use --section parameter of pg_dump and
> > pg_restore, which is available only in 9.2.
> >
> > 1. Is it, in general, safe to use 9.2 tools on 8.4 server?
On Mon, 2012-12-17 at 17:10 +0100, Baptiste LHOSTE wrote:
> > It could be dead rows, still visible for other transactions.
>
> Ok but in this case, why the automatic vacuum task of the autovacuum process
> does not delete theses dead rows ?
>
As I said, because they are still visible to other
On Mon, 2012-12-17 at 16:57 +0100, Baptiste LHOSTE wrote:
> Hi everybody,
>
> I have trouble understanding some logs of postgreSQL.
>
> Here you can find a log from the auto-vacuum process :
>
> 2012-12-17 16:38:58 CET LOG: automatic vacuum of table
> "flows.public.agg_t344_outgoing_a41_src_ne
On Tue, 2012-05-29 at 08:14 -0700, Steve Crawford wrote:
> On 05/26/2012 12:38 PM, Michael Shapiro wrote:
> > PgAdmin doesn't retain the saved passwords when a connection to a
> > server fails.
> >
> > I'd like to request that the saved passwords be kept, even in the
> > event of a failure.
> >
>
On Sat, 2012-02-25 at 09:23 -0700, Scott Ribe wrote:
> On Feb 25, 2012, at 9:18 AM, Brian Weaver wrote:
>
> > Thanks for the pointer. Is it just me that finds it the behavior of
> > pg_restore odd? If the default installation since 9.0 has PL/PgSQL
> > installed then why does pg_restore still em
On Fri, 2012-02-24 at 22:12 -0500, Brian Weaver wrote:
> So when did the installation of PL/PgSQL into all databases become standard
> operating procedure? It wasn't standard (or at least it didn't choke) on
> the installation of versions 8.3 and 8.4 that I have used on CentOS 5.
>
> Seems like a
On Fri, 2012-02-10 at 07:45 -0700, Greg Spiegelberg wrote:
> All,
>
> I'm planning a migration for a customer with a PostgreSQL 8.4 database
> cluster running CentOS 4.8 32-bit. The target platform is CentOS 6.2
> 64-bit and will be running PostgreSQL 8.4 (our application delivers and
> supports
On Thu, 2012-02-02 at 15:40 +0100, Mario Splivalo wrote:
> How can I get the master server host data from a running slave, without
> reading recovery.conf file?
>
> I've tried with SHOW, but that just gives me:
>
> postgres=# show primary_conninfo;
> ERROR: unrecognized configuration parameter "
On Tue, 2012-01-10 at 11:33 -0800, Tripura wrote:
> I have a Postgresql database with 3 Schemas (2 user defined and 1 public).
>
> I have script that takes backup of the user defined schema's and then drops
> the schema's.
>
> Now after doing some operations I want to restore the user defined sch
On Thu, 2012-01-05 at 22:23 +0100, Wujek Srujek wrote:
> Yes, pgAdmin is pretty much the only thing I use after initially installing
> and setting the password for the 'postgres' user.
> When does it do it? How did I trigger that?
>
It does that when you tell it to record your password (checkbox
On Thu, 2012-01-05 at 22:00 +0100, Wujek Srujek wrote:
> Hi. Yes, there is such a file, and yes, it is the 'special' thing I was
> looking for. Thanks you very much for the tip, I did some reading about it.
> Who created this feature for me? Could it be the ubuntu installation
> process?
>
No, I
On Thu, 2012-01-05 at 20:56 +0100, Wujek Srujek wrote:
> Hi. I am using Postgres 9.1 on Ubuntu 11.10 64bit. I have a question about
> client authentication.
> After installing the server, and setting the postgres password to encrypted
> 'postgres', I made sure I can log in like that. Then, I edited
On Tue, 2011-12-27 at 15:55 +0100, Daniel Vázquez wrote:
> How to get a list of contrib module installed extensions on Postgresql
> 8.4??
>
If you mean installed on the OS, it's impossible from the SQL command
line. If you mean installed on your database, it's difficult to know.
You need to check
On Tue, 2011-12-27 at 13:01 +0530, nagaraj L M wrote:
> Hi sir
> Can u tell how to take back up individual schema in
> PostgresQL
>
Use the -n command line option
(http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html).
--
Guillaume
http://blog.guillaume.lelarge.i
On Mon, 2011-09-26 at 16:06 +0530, Mridul Mathew wrote:
> Hello,
>
> I wanted to take a moment here and reach out to the community with a
> question. How does postgreSQL handle schema switching in the database? I
> have a test scenario.
>
> ##
>
> vpn2=> show search_path;
> sear
On Tue, 2011-09-20 at 15:55 -0400, Tom Lane wrote:
> Marc Fromm writes:
> > Can I use "RETURNING id" in an insert statement with postgresql version
> > 8.1.10?
>
> No. I don't recall just when RETURNING was added, but for sure it was
> after 8.1.
>
I checked. It appeared in 8.2. Sooner than I
On Wed, 2011-09-14 at 04:03 -0700, Rob Audenaerde wrote:
> I have a Postgresql 8.3 instance with tablespaces totalling on about 74G.
> This is fine.
>
> But if I ask Postgresql how big my database is, I get a (unexpected) large
> answer: 595 GB.
>
> This seems very strange. Disk I/O tests on th
On Tue, 2011-09-13 at 14:47 +0200, Johann Spies wrote:
> Thanks Giulio and Gabriele,
>
> > as Giulio pointed out, it seems like the destination database is in
> > LATIN1 encoding, rather than UTF8. Could you please confirm this?
>
> That was the case. I deleted one of the databases and rec
On Mon, 2011-09-12 at 13:42 -0500, Peter Koczan wrote:
> Is there any way to set an access log for a specific table?
>
> What I'd like to do is have a record of all access for one table. It
> would be nice to do this by raising a notice and having it show up in
> syslog. I could use triggers, but
Hi,
On Mon, 2011-09-12 at 15:09 +0100, Adrian Heath wrote:
> [...]
> pgAdmin 1.14 REL:1_14_0 (build included with official postgresql 9.1 MS
> Windows 32 binary)
>
> Selecting "backup globals" fails with "illegal option --global-only" as
> it runs pg_dump.exe instead of pg_dumpall.exe
>
You'r
On Mon, 2011-09-12 at 11:59 +0200, Marc Mamin wrote:
> differentiated memory settings
>
> Hello,
>
> I need to implement differentiate memory settings in order to favor some
> given operations.
> (see function below)
>
> I miss an admin function to reset the settings to the initial values.
>
>
On Sun, 2011-09-11 at 01:19 +0800, Rural Hunter wrote:
> I'm making a base backup with 9.1rc by following 24.3.3 in manual:
> http://www.postgresql.org/docs/9.1/static/continuous-archiving.html
> 1. SELECT pg_start_backup('label');
> 2. perform file system backup with tar
> 3. SELECT pg_stop_backu
On Thu, 2011-09-08 at 19:09 +0100, Richard Shaw wrote:
> Hi,
>
> I'm looking to move a database by using ALTER DATABASE $DB SET TABLESPACE
> and i'd also like to move a schema over to the same new tablespace, googling
> around, it looks like there was a an ALTER SCHEMA $SCHEMA SET TABLESPACE
>
On Sat, 2011-07-09 at 11:58 +, Greg Sabino Mullane wrote:
> > Is it possible to start a postgres cluster or 1 postgres database in
> > readonly mode? And - if yes - how can this be done?
>
> Clusterwide: edit postgresql.conf and set
> default_transaction_read_only = on;
>
> No restart needed,
On Wed, 2011-06-08 at 11:36 +0100, Thorne, Francis wrote:
> In postgres 8.3.6 could you please tell me where the security
> permission details for users are stored (i.e. who has select on a
> particular table)
Column relacl in the pg_class table of the pg_catalog schema.
> , for example in the ma
On Tue, 2011-06-07 at 11:33 -0700, A J wrote:
> >>To return to normal operation, a standby server must be recreated,
> either on the former primary system when it comes up<<
>
>
> What does it exactly mean to 'recreate a standby server' ? Can I not
> use the datafiles on the former primary and ju
On Fri, 2011-06-03 at 11:07 -0700, Michael Holt wrote:
> I'm investigating moving from slony to streaming replication as we
> plan some upgrades from 8.x versions of postgres to 9. I've managed to
> get it working but there's a couple questions I've been unable to find
> answers to so far.
>
> 1)
Le 05/19/2011 02:27 PM, Vipul Kumar Singh02 a écrit :
> [...]
> A Data dump from a PostgresSQL server was created using Postgres Version
> (PostgreSQL 7.4.1 on i386-unknown-freebsd5.3, compiled by GCC gcc (GCC) 3.4.2
> [FreeBSD] 20040728).
>
> Now i am trying to import into PostgreSQL Server 4.8
Le 05/12/2011 03:52 AM, Wells Oliver a écrit :
> If I'm understanding things, pg_dump will not dump casts b/c they are system
> objects and belong to neither schema nor database.
It doesn't dump system casts because they are system objects, and so
always available. But it does dump user casts.
-
On 05/03/2011 05:52 AM, Tom Hartnett wrote:
> can it be done?
>
> create index my_idx on my_table(col1) where col1='';
>
> ERROR: invalid input syntax for integer: ""
>
> Seems simple enough but I don't know what the trick is.
>
col1 is an integer, not a string. And you cannot check for empty
Le 26/04/2011 18:38, Vick Khera a écrit :
> On Tue, Apr 26, 2011 at 11:36 AM, Willy-Bas Loos wrote:
>
>> I don't get it, they should have been analyzed at restore, should they not?
>>
>
> I do not believe analyze is part of the restore process. You must
> explicitly run it.
>
That's almost tr
Le 30/03/2011 16:13, Gnanakumar a écrit :
> [...]
> Our OS is CentOS5.2. We're upgrading our PostgreSQL database from v8.2.3 to
> v9.0.3. Is there any default init script available in v9.0.3 for starting
> up the PostgreSQL server so that it can be added to "/etc/init.d/"? I
> couldn't find any
Le 28/03/2011 15:44, Shridhar Polas a écrit :
> [...]
> Is there a way to create triggers on system catalog tables like
> pg_class, pg_attribute etc...?
>
No.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make c
Le 24/03/2011 11:32, Jaroslav Záruba a écrit :
> You nailed it! :)
>
> My regular user has .pgpass, root does not.
> When I remove the --host (and --port) arguments it works like charm. :)
>
> Thanks a lot, Guillaume!
>
You're welcome :)
--
Guillaume
http://www.postgresql.fr
http://dalibo.
Le 24/03/2011 10:39, Jaroslav Záruba a écrit :
> The command line is still the same, when executed under one user it does not
> ask for password, when executed under another (root that is) it does:
> pg_dump --ignore-version --host=localhost --port=5432 --username=postgres
> --file="$BACKUP_FILE" -
Le 24/03/2011 10:05, Jaroslav Záruba a écrit :
> My pg_hba.conf looks like this:
>
> local all postgrestrust
> host all postgres 192.168.1.0/24 md5
> local all all ident
> host all all 127.0.0.1/32 md5
> host all all ::1/128 md5
>
>
Still lacks the complete pg_dump command lines (bo
Please, answer to the list.
Le 24/03/2011 09:13, Jaroslav Záruba a écrit :
> Yes, it is the password for PostgreSQL.
>
> pg_dump: [archiver (db)] connection to database "db123" failed: FATAL:
> password authentication failed for user "postgres"
> FATAL: password authentication failed for user "
Le 24/03/2011 08:34, Jaroslav Záruba a écrit :
> Hello
>
> I have pg_dump command in cron that accesses PostgreSQL under user postgres
> and does not provide a password.
>
> pg_dump --username=postgres ...
>
> I have set in pg_hba.conf that user postgres should be trusted for all
> databases fro
Le 10/03/2011 02:16, Selva manickaraja a écrit :
> Hi All,
>
> We are using Tsung to load and stress test postgresql. Tsung runs such a way
> that it need the application to use a port that Tsung listens to as a proxy.
>
> So in our case we need psql to use Tsung as a proxy to ulimately connect t
Le 07/03/2011 11:54, Lukasz Brodziak a écrit :
> Here it is: http://img69.imageshack.us/i/errorjn.png/
>
> Again, when I perform AdminPack.sql in pgAdmin I don't get the error.
>
You don't do the same thing. If "performing" adminpack.sql is executing
it, you also don't have an error with psql wh
Le 07/03/2011 11:39, Lukasz Brodziak a écrit :
> I still have the same error. Is there any other way of running the
> script outside pgAdmin?
>
Can you give us the real error message you get?
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
--
Sent via pgsql-admin mailing list (pgsq
Le 07/03/2011 09:17, Lukasz Brodziak a écrit :
> Hello,
>
> I have a problem with creating function through script ran in psql.
> I'm running the script AdminPack.sql from the contrib package using
> this statement:
> sudo su postgres -c psql MyDB <
> /usr/share/postgresql/8.2/contrib/adminpack.s
Le 21/02/2011 02:04, Selva manickaraja a écrit :
> I encountered a small issue when I run the script in the old-primary. The
> "SELECT pg_start_backup" part of the script will fail since the
> postgres service has been stopped. Is this error meant to happen?
>
The "SELECT pg_start_backup...
Le 11/02/2011 18:14, Stefanie Weykam a écrit :
> Thanks, Guillaume, but I only found a history_db.xml file under the
> Windows directory - and no success either.
> What else can I try??
>
By default, the filename is pgadmin_histoqueries.xml. So, unless you
changed it, you should look for it. And
Le 11/02/2011 12:33, Stefanie Weykam a écrit :
> Hi list members,
> I ran into a similar problem as these ones:
> http://archives.postgresql.org/pgadmin-support/2010-09/msg6.php
> http://postgresql.1045698.n5.nabble.com/pgAdmin-Query-Tool-hangs-when-working-with-GIS-data-td3309962.html
>
>
>
Le 11/02/2011 05:43, Selva manickaraja a écrit :
> We are considering on using a primary and 2 secondary machines. But our plan
> is to cascade the recovery as follows:
>
> 1. Primary Machine-A (read and write operation)
> 2. Secondary Machine-B (recover from Machine A)
> 3. Secondary Machine-C (r
Le 09/02/2011 00:27, Marc Fromm a écrit :
> Yes, the database server is on the same server as the http server.
> The complete error message is just "Login failed."
>
> There is nothing in the pg_log file, that the FAQ's say to check.
>
How did you configure phpPgAdmin?
--
Guillaume
http://ww
Le 08/02/2011 23:23, Marc Fromm a écrit :
> I installed phpPgAdmin on my red hat box in the /var/www/html directory.
> I edited the pg_hba.conf file as many tutorials stated with the lines.
> local allall
> trust
> host all
Le 08/02/2011 10:27, Antonio Biondo a écrit :
> Hi, tnx for the answer. Do you think that will be add a option in the
> menù for query editor too? Mysql workbench has it, i would appreciate it
> in Pgadmin III...
>
No. The user writes his query, I'm not sure he would like we mess with
it adding d
Le 07/02/2011 12:14, Julius Tuskenis a écrit :
> 2011.02.07 11:52, Guillaume Lelarge rašė:
>> Did you lower each report? because each individual report has its own
>> timer.
>>
> I'm sorry, I have only one report (Server status window). When you say
> "lower
Le 07/02/2011 09:31, Julius Tuskenis a écrit :
> Hello, all!
>
> Last Friday I've installed pgAdmin 1.12.2 (build Dec 13, 2010) into one
> of our clients servers (Windows server 2003 SE SP2). Postgresql 8.3.3
> runs on it. As we were looking how to improve performance we were using
> Server Status
Le 01/02/2011 18:44, Antonio Biondo a écrit :
> Hi, i not found in query tool of PgAdmin III the option to set "maximum
> rows to retrive". Is there no this option?
>
This option only exists in the data grid. If you need this in the query
editor, add a LIMIT clause on your queries.
--
Guillaum
Le 23/12/2010 15:14, Mark Watson a écrit :
> Hello group,
> Any suggestions as to how to fix this are greatly appreciated.
> My setup is Vista, locally installed Postgres 8.4.6 in default folders with
> db initialised as (server_encoding) UTF8, and databases created with default
> encoding of WIN12
Le 13/12/2010 21:41, Fred Parkinson a écrit :
> Thanks again for your great help.
>
> I ran adminpack.sql in the query window and it returned 'success'.
>
> I actually did read the complete message and it was (slightly) vague
> enough that I thought there was a chance it didn't just apply to th
Le 13/12/2010 21:42, paulo matadr a écrit :
> [...]
> I made an backup of database 8.3
> test.dmp
> and tested restore in (8.4.5) using parallel
> pg_restore -d xxx -n yyy -t -j 3 < test.dmp
>
> And give error:
> pg_restore: [custom archiver] cannot reopen stdin
> pg_restore: [archiver
Le 13/12/2010 21:03, Dinesh Bhandary a écrit :
> Hi All - Is log_file_mode parameter available for postgres 9.0 only? Ran
> into a bit of problems with log permission and came across a new GUC
> "log_file_mode". But I could not seem to find much docs on it and I am
> not sure if it is production re
Le 13/12/2010 18:28, Fred Parkinson a écrit :
> New to managing postgresql, I hope my questions are not a burden to this
> group, but I have another.
>
> I have installed version 8.4.5 of postgresql, 1.12.1 of pgadmin3.
>
> When I invoke pgadmin3 from a terminal prompt I get the message that
Le 13/12/2010 17:20, Fred Parkinson a écrit :
> I am a longtime user of postgersql, using it as a backend and using odbc to
> connect and it has been an amazingly stable and useful database manager.
>
> Now, a longtime Windows user (disgruntled) I am trying to set up a
> development platform on
Le 08/12/2010 11:04, Manasi Save a écrit :
> Also I want to query multiple databases from stored functions from one
> central database.
> for ex :=
>
> CREATE OR REPLACE FUNCTION test () RETURNS AS
> $BODY$
>
> SELECT * FROM db2.volume
> ORDER BY db2.volume.volumeID
>
> $BODY$
> LANGUAGE sql S
Le 08/12/2010 10:43, Manasi Save a écrit :
> [...]
> I want to create postgresql database and tables using stored functions.
>
> Does postgresql support create statements in stored functions.
>
You cannot use CREATE DATABASE from a stored function or in a
multistatements query. But AFAICT, any
Le 04/12/2010 02:45, Josh Berkus a écrit :
>
>> I've encountered this before, psql gives me a syntax error for no clear
>> reason. It's allways on the first character of a sql file.
>> I think that there must be some strange character code at the first
>> position, maybe it is because i share a nt
Le 25/11/2010 11:02, Gera Mel Handumon a écrit :
> Hello,
>
> What version of pgadmin3 to be used for postgresql 9 running on CentOS
> 5? I encountered some errors when i used the pgadmin3 1.8.4. I've
> search for newer version of pgadmin3 for Linux but no luck at all.
>
You need the 1.12 releas
Le 23/11/2010 13:24, tomislavb a écrit :
> [...]
> i've seen this is a popular topic but haven't found any concrete answers so
> far.
> So my scenario is this :
>
> - created a new user with :
> sudo -u postgres createuser -D -A -P john
>
> - created a new database with :
> sudo -u postgres creat
Le 15/11/2010 20:42, Chris Ruprecht a écrit :
> Hello,
>
> I was wondering if there is a way to pre-allocate tablespace on disk before
> adding data and indexes.
> My understanding is:
> PG writes data into files sequentially. If more space is needed, disk space
> is requested from the OS and if
Le 12/11/2010 18:37, Ricardo Bayley a écrit :
> Hi,
>
> I am wondering if there is a way to identify which columns have been
> modified. Is there some sort of TG_TABLE_NAME, which states the
> modified columns ?
Nope. You should check yourself.
> Or should we check this ourselves doing something
Le 23/10/2010 03:08, Guillaume Lelarge a écrit :
> Le 20/10/2010 05:38, maie...@poczta.onet.pl a écrit :
>> pgAdmim 1.12 on WinXP SP3 but this issue was observed in previous releases
>> also
>>
>> When in table view window applied filter and no rows returned (no row
Le 20/10/2010 05:28, maie...@poczta.onet.pl a écrit :
> I am running pgAdmim 1.12 on WinXP SP3 but this issue was observed in
> previous releases also.
> When trying to do a backup of a table which has quotation marks in its name
> or in schema name then getting error:
> (example1 quotation marks i
Le 20/10/2010 05:38, maie...@poczta.onet.pl a écrit :
> pgAdmim 1.12 on WinXP SP3 but this issue was observed in previous releases
> also
>
> When in table view window applied filter and no rows returned (no row
> matches the filter rull) then it is not possible to fire context menu of the
> grid
Le 13/10/2010 23:20, Guillaume Lelarge a écrit :
> Hi Kasia,
>
> Le 13/10/2010 22:21, Kasia Tuszynska a écrit :
>> [...]
>> Thanks for your reply I did a bit more testing with the superuser priv
>> issue, and now I came to the conclusion that pgAdminIII may b
Le 15/10/2010 21:31, Tom Lane a écrit :
> Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes:
>> On Fri, 2010-10-15 at 12:18 -0700, Isabella Ghiurea wrote:
>>> ERROR: column t.tgisconstraint does not exist at character 387
>
>> Could it be a non-9.0 aware client software?
>
> So it would appear. pgAdm
Le 15/10/2010 00:53, Shoaib Mir a écrit :
> On Fri, Oct 15, 2010 at 9:39 AM, Guillaume Lelarge
> wrote:
>
>> Le 14/10/2010 23:18, Rudolf van der Leeden a écrit :
>>> [...]
>>> quick question to the PG 9 community.
>>>
>>> I can query a hot stand
Le 14/10/2010 23:18, Rudolf van der Leeden a écrit :
> [...]
> quick question to the PG 9 community.
>
> I can query a hot standby server if recovery is still active using
> the administration function pg_is_in_recovery(). Is there also a way
> to query for the 'primary server', i.e. which server
Le 13/10/2010 18:48, Ozer, Pam a écrit :
>
> All of a sudden yesterday my Postgres Service stopped on my local
> connection. I was able to restart the service in PGAdmin but now I
> can't connect to the database through PGAdmin. My application can still
> connect but I can't. It keeps asking fo
Hi Kasia,
Le 13/10/2010 22:21, Kasia Tuszynska a écrit :
> [...]
> Thanks for your reply I did a bit more testing with the superuser priv issue,
> and now I came to the conclusion that pgAdminIII may be doing something silly.
>
Sure, that happens more than I would like.
> I created a user: bob
Hi,
Le 12/10/2010 19:25, Kasia Tuszynska a écrit :
> [...]
> 1.Permissions:
> When I create a login role with superuser privileges in pgAdminIII I have the
> option of indicating that the superuser will also have the permission to:
> "can modify catalog directly", when I look at the sql that
Le 05/10/2010 05:28, Fábio Gibon - Comex System a écrit :
> [...]
> are there some tool or internal program that read a dump file (created by
> pg_dump) and list all tables and number of tuples (without
> restore) in this file?
>
That command should give you the number of tables in your plain d
Le 30/09/2010 17:50, Terry Schmitt a écrit :
> [...]
> I had a situation where a session was getting blocked while per
> performing a pg_dumpall.
>
> I could see the pg_dumpall session executing a COPY command on a table
> in one schema.
> Another user session was attempting to truncate a differen
Le 29/09/2010 10:16, Michal Glowacki a écrit :
> Fujii, I believe I should follow this (from documentation):
>
>
>
> The procedure for making a base backup is relatively simple:
>
> 1.
>
> Ensure that WAL archiving is enabled and working.
>
> 2.
>
> Con
Le 24/08/2010 11:44, Jens Wilke a écrit :
> Am Dienstag 24 August 2010 11:35:43 schrieb Kieren Scott:
>
> Hi Kieren,
>
>> but I was wondering if there were any good tools available
>> for monitoring such things as whether all of my postgres cluster's were up
>> and running
>
> Have a look for
Le 10/07/2010 12:43, Neuber, Dirk a écrit :
>>> What is it?
>
>> Why don't you tell us?
>
>> The exact name of the file might be useful information, too.
>
> It is : postgres/8.3/main/base/16385/2613
>
This is a system catalog, pg_largeobject, which holds binary objects. If
you use Large Objec
Hi,
Le 19/06/2010 01:09, John Rouillard a écrit :
> [...]
> We are using postgres 8.4.4 as distributed in centos 5.5.
>
> We have a database that has a number of partitioned tables
> (http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html).
>
> We would like to add a read only use
Hi,
Le 14/05/2010 14:52, Narasimha Murthy-VRFX87 a écrit :
> [...]
> I need a clarification on auto-vacuum. Appreciate any
> clarification/help.
>
> As explained in page 1093 of postgresql-8.2-US.pdf, VACUUM command works
> either in plain mode (if we do not specify FULL) or in FULL mode. When
>
Le 13/04/2010 20:16, Mitch Collinsworth a écrit :
> [...]
> I thought I understood how this worked, but now it's baffling me.
> I want to drop a database named coral from my test server and load
> a fresh dump of it from my production server. This has worked when
> I've done it before, but now it'
Hi,
Le 18/04/2010 12:09, Feris Thia a écrit :
> [...]
> I've just maintain my postgresql server 8.1 which has a database of 470 GB
> in size. What I mean by maintenance is to vacuum analyze it. And now it
> looks faster to accesss every tables in that database.
>
> What I want to do is to set aut
Le 06/04/2010 20:45, Francisco Reyes a écrit :
> Kevin Crain writes:
>
>> How do I configure postgres to lock a user's account after X failed
>> login attempts, where X is an arbitrary number.
>
> Don't think there is a way to do that.
> Perhaps using an authentication mechanism that supports tha
Le 05/04/2010 06:08, Nilesh Govindarajan a écrit :
> On 04/05/10 08:54, Scott Marlowe wrote:
>> On Sun, Apr 4, 2010 at 8:21 PM, Nilesh Govindarajan
>> wrote:
>>> Hi,
>>>
>>> I wish to execute VACUUM FULL when DB touches a specific size. How to
>>> do it
>>> ?
>>>
>>> I'm aware about the caveats of
Le 02/04/2010 15:38, Kevin Grittner a écrit :
> "Gnanakumar" wrote:
>
>> I connect to our database which is hosted remotely using PuTTY
>> thro SSH protocol.
>
>> my Internet got disconnected in the middle,
>> so database cloning was also stuck in the middle.
>
>> 4. Considering this Inter
Le 31/03/2010 12:51, Gnanakumar a écrit :
> After restarting PostgreSQL, I can see the following parameters are set to
> ON:
> mydb=# show stats_start_collector;
> stats_start_collector
> ---
> on
> (1 row)
>
> mydb=# show stats_start_collector;
> stats_start_collector
> ---
Le 31/03/2010 11:14, Gnanakumar a écrit :
> OK. I'll try that way.
>
> But, as per 8.2 doc, by default it is ON. So if I comment with just '#'
> infront of the parameter, and restart PostgreSQL, this change will not be
> reflected, which means it should work with default value ON?
Yes, you're ri
Le 31/03/2010 10:58, Gnanakumar a écrit :
> I’m also seeing a weird thing. If I do ‘show stats_start_collector;’ inside
> psql, it says ‘off’.
>
> I’ve also restarted my server many times after making all the changes.
>
> As per 8.2 doc,
> http://www.postgresql.org/docs/8.2/interactive/runtime-c
Le 31/03/2010 08:41, Gnanakumar a écrit :
> Hi,
>
>
>
> Even though I've enabled statistics collector in our server, it is not
> collecting statistics, and because of this autovacuum is also not running as
> expected.
>
>
>
> PostgreSQL version 8.2
>
>
>
> Parameters enabled related to
Le 29/03/2010 11:31, "Martin Münstermann" a écrit :
> [...]
> is it safe to move the PGDATA directory from one system to another when
> migrating from one operating system to another?
> For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5?
> The database is of course shutdown properl
Le 29/03/2010 04:04, Nilesh Govindarajan a écrit :
> Hi, it seems to be working now. Can somebody explain to me how ? See
> this pg_hba.conf -
>
> # "local" is for Unix domain socket connections only
> local all root trust
> local all all md5
> # IPv4 local connections:
> #host all root 127.0.0.1/
Le 28/03/2010 19:11, Nilesh Govindarajan a écrit :
> [...]
> I'm trying to setup PostgreSQL so that, it will not ask password when
> connected locally (socket) whereas it will ask when connected using
> TCP/IP. This should apply ONLY to root account. But this is not working -
>
> local all root tr
Le 27/03/2010 14:00, Gnanakumar a écrit :
> [...]
> We're using PostgreSQL 8.2. Recently, in our production database, there was
> a severe performance impact.. Even though, we're regularly doing both:
>
> 1. VACUUM FULL ANALYZE once in a week during low-usage time and
>
> 2. ANALYZE eve
Le 19/03/2010 15:39, Julius Tuskenis a écrit :
> 2010.03.19 16:20, Guillaume Lelarge rašė:
>> Yes. It would also be easier to debug.
>>
> I guess so, but is there no way to tell the postgres that I'm listing
> the field names and there is no place for a parameter
Le 19/03/2010 14:45, Julius Tuskenis a écrit :
> Hello
>
> lets say I have a function add_user(user varchar(20), password
> varchar(20)). In its body I want to have statement INSERT INTO
> my_users(user, password) VALUES (user, password); The problem is I cant
> - then I try to create such functio
Le 18/02/2010 22:56, Brad Littlejohn a écrit :
> [...]
> I'm pretty sure that this is a FAQ here, but I'll ask it, just to get
> confirmation on what I need to do.
>
> I have a database sitting on a box running PostgreSQL 8.4, checking in at
> 190GB. I performed a backup of the database, using p
Le mercredi 16 décembre 2009 à 06:18:45, Gurjeet Singh a écrit :
> 2009/12/15 Guillaume Lelarge
>
> > Le mardi 15 décembre 2009 à 00:04:47, Evan Rempel a écrit :
> > > Is there a command/tool that will report on how FULL a table is
> > > getting? If ther
Le mardi 15 décembre 2009 à 00:04:47, Evan Rempel a écrit :
> Is there a command/tool that will report on how FULL a table is getting?
> If there is, how intrusive is it? How computationally heavy is it?
>
> We have a database that is approx 100 million rows with
> approx 2 million insert/updates
1 - 100 of 145 matches
Mail list logo
