Olivier Boissard a écrit :
> I'd like to compare postgresql tables content between 2 servers after a
> replication.
> Do you know which tools can do this ?
>
If you don't mind using a non-free product, there are DB Comparer for
PostgreSQL (http://sqlmanager.net/fr/products/postgresql/dbcomparer)
Olivier Boissard a écrit :
> Guillaume Lelarge a écrit :
>>[...]
>> If you don't mind using a non-free product, there are DB Comparer for
>> PostgreSQL (http://sqlmanager.net/fr/products/postgresql/dbcomparer) and
>> Data Comparer for PostgreSQL
>> (http:/
Bruce Momjian wrote:
> Alvaro Herrera wrote:
>> [...]
>> Hmm, do we include the cvs2cl-generated ChangeLog in the tarballs?
>
> No, we don't. We used to but the file got too large. Perhaps we should
> supply a URL that generates that information.
>
That would be great. +5 :)
Regards.
--
Guil
Jim C. Nasby a écrit :
> On Tue, Jul 17, 2007 at 06:45:29PM +0300, Abraham, Danny wrote:
>> Can someone help? Need a plpgsql debugger.
>
> You can get our debugger from the bottom of
> http://www.enterprisedb.com/downloads.do
But he needs to use EnterpriseDB Advanced Server to use EnterpriseDB
PL
Scott Marlowe a écrit :
> On 7/17/07, Guillaume Lelarge <[EMAIL PROTECTED]> wrote:
>> Jim C. Nasby a écrit :
>> > On Tue, Jul 17, 2007 at 06:45:29PM +0300, Abraham, Danny wrote:
>> >> Can someone help? Need a plpgsql debugger.
>> >
>> >
Alvaro Herrera a écrit :
> Kevin Kempter wrote:
> [...]
>> b) a list of tables in the db and the last time they were vacuumed
>
> Examine the pg_stat views, though I am not sure if the vacuum columns
> were already in 8.1. In any case, in 8.1 Xid wraparound is tracked
> per-database, so you need
[EMAIL PROTECTED] wrote:
> You're right .
> I will begin by migrate postgresql version.
> postgresql is now to 8.3 version . A lot of performance inprovements
> have been made in this last version .
> In any case I must do a pg_dump/pg_restore.
> So , Should I try directly 8.3 version or is it more
Tom Lane wrote:
> "ivan.hou" <[EMAIL PROTECTED]> writes:
>> step 1. SELECT datname, age(datfrozenxid) FROM pg_database;
>> --> mydb age:33183
>> step 2. SELECT datname, age(datfrozenxid) FROM pg_database;
>> --> mydb age:33188
>
>> why always increased by 5?
>
> If you do it directly in psql, it
Alvaro Herrera wrote:
> Guillaume Lelarge wrote:
>
>> We first send the query to the database. For each returned column, we
>> send two queries. The first one gives us the type's name of the column
>> and the second one gives us the OID of the base type. So, each que
ivan.hou wrote:
> how do u know this theory ? 1 + (2 * number of columns in the SELECT)
> just try & test?
I did this at first, yes. I changed log_statement to all, reload the
configuration, and voila. I've seen that pgAdmin's query tool executes
this number of queries to display the result.
> or
Chris Hoover wrote:
I'm running PG 8.3rc2 to start testing it out, and really like how it is
preforming for me so far. However, I have one question on the logging.
I am trying to use syslog and csvlog to log all sql. This seems to work
great except that for every log rotation postgres does,
Kasia Tuszynska wrote:
I am searching for a pg_x view that would allow me to view the
properties of an index.
- the fillfactor it was created with
Catalog pg_class, column reloptions.
- the amount of free space on a page(s) storing the index ( assuming
that it was created with a fillfact
Brad Nicholson wrote:
Say I'm using pg_standby to feed wal files from database A into both
database B and database C.
At some point, I lose A, so I bring Database B up and start the wal
archiving from there. Can I then continue streaming the wal files from
B into C, or do I need to take a new b
Tom Lane wrote:
"Jonah H. Harris" <[EMAIL PROTECTED]> writes:
On Feb 5, 2008 11:54 PM, Decibel! <[EMAIL PROTECTED]> wrote:
One of the things that drew me to Postgres years ago was that I could
actually read about how it works in a clear, concise manner.
Agreed.
Not sure how you could argue
Nuwan Liyanage wrote:
Ok I think I got it. I just went ahead and updated the pg_database table
and it works..
A better way is to connect to another database (template1 for exemple,
but you would better use another one) and fire your statement there.
Updating system table can be dangerous.
Hi,
Gerd König a écrit :
we're quite new to Postgres and we're going to start using Postgres8.3
on Opensuse10.3 64 bit. We have a dedicated dbserver with 8GB RAM, and
now I'm not sure how to deal with the memory/buffer settings. The db
will be accessed heavily (~20 requests/sec.) with a read/w
Hi,
Barbara Stephenson a écrit :
We are new about autovacuum launcher on 8.3.1 and we are not sure what the
parameters should be set to. Is setting them to default ok until we can
monitor if it's vacumming too much?
You can do that. But the default are, as always with PostgreSQL, really
c
MARIOTTI, Alessandro (Alessandro) a écrit :
I’m writing you to get some information regarding the possibility to get
some information a db corruption got yesterday morning in a live platform .
We realized DB Inconsistence and corruption and we tried to restore
immediately the DB , via a back-u
MARIOTTI, Alessandro (Alessandro) a écrit :
Well I could shortly describe what's happen on these machines ;
On May 7 2008 at 23:25 an operator performed :
_a configuration change ;
_add a new user on a table named MVNO;
None of these could have caused a corruption.
Customer told us that f
Tom Lane a écrit :
Marc Cousin <[EMAIL PROTECTED]> writes:
I'm having a problem with plpgsql functions leaking memory.
Your example shows absolutely no memory leak here, in either 8.3.3
or CVS HEAD.
I see the postgresql process growing from 8MB to about 400 MB during this
run...
What do yo
Tom Lane a écrit :
Guillaume Lelarge <[EMAIL PROTECTED]> writes:
Tom Lane a écrit :
What do you have shared_buffers set to? I think you might be getting
fooled by top's treatment of shared memory (ie, it starts to count
shared pages after the process touches them for the first time
Jagadeesh a écrit :
> On Oct 10, 9:42 am, Jagadeesh <[EMAIL PROTECTED]> wrote:
>>[...]
>> how can I invoke editor like vim from postgres? This helps me in
>> editing large and complex queries.
>> Thanks
>
> I just got to know emacs can be used for it. Is there any other
> method?
> I am using Free
Martin A. Brooks a écrit :
> Guillaume Lelarge wrote:
>> Martin A. Brooks a écrit :
>>
>>> However, in the log files, I'm seeing entries for all SQL executed, not
>>> just that taking 5000ms or more. For example:
>>>
>>> 2008-10-14 10:15
Martin A. Brooks a écrit :
> Hi
>
> I want to have postgres log sql statements that take longer than 5
> seconds to execute. In postgresql.conf I have set
> log_min_duration_statement as follows:
>
> [EMAIL PROTECTED]:/etc/postgresql/8.3/main# grep log_min_duration
> postgresql.conf
> log_min_du
Florian Weimer a écrit :
> We've set up WAL-shipping replication on one of our database servers,
> and the question is whether it runs correctly. Is there an easy way
> to access some tables and see if the data matches (possibly in
> single-user mode)?
>
Nope. The only way you can look at data o
Isabella Ghiurea a écrit :
> where can I download a copy of oid2name source code?
It's available with PostgreSQL source code
(http://www.postgresql.org/ftp/source/).
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or
Alexander Strotmann a écrit :
> [...]
> we are running a CRM system with Postgres database (version 8.3). To
> organize handwritten contracts we save them scanned as LOBs. Normally
> they are unlinked in case of deleting them. However we run a cron job
> which does vacuumlo to get save that there i
Michael Monnerie a écrit :
> On Mittwoch 06 August 2008 Torsten Luettgert wrote:
>> reindexdb dbname
>> vacuumdb -f -z dbname
>
> Just a question on this: Is the order correct or would a vacuum+reindex
> be more correct?
>
You should do a VACUUM and then a REINDEX.
--
Guillaume.
http://www.
Jaume Sabater a écrit :
> [...]
> Sorry to ask this, I had it noted down but now I cannot find it and
> I've been googling for 30 minutes now without success. There is a way
> to query the system database to get the current value of a
> configuration parameter, something in the form of SELECT value
Tino Schwarze a écrit :
> [...]
> I'm going to pg_restore a database dump of about 220 GiB (uncompressed,
> but most data is BLOBs). The machine has 8 GiB of memory and 8 cores.
> Is there any advice to speed up restoring, postgresql.conf-wise?
>
> I already have a script which does the data loadi
Hi,
Michail Karataev a écrit :
> [...]
> Are there any FREE tools like Maestro SQL for postgres that i can run under
> many various systems (windows, mac, linux, freebsd). One of the most
> important future for me is browsing database structure as a scheme with
> tables and relations beetwin them
Le mercredi 25 mars 2009 à 14:35:36, Nicolas Michel a écrit :
> [...]
> I already have an instance with a database. I want to move the WAL files
> to an other hard disk to have a better speed.
> I read that I had to create a symbolic link to do that. Is there another
> "cleaner" way : an option in
Le lundi 30 mars 2009 à 16:39:59, toni hernández a écrit :
> [...]
> I've been trying to import some data from a csv file to my database.
> I have some fields of the table that I want to keep so I typed
>
> copy mytable (column
> Affidabilita_stratigrafica,Ambiente,Anno,Componenti_geologici) FROM
>
Le jeudi 09 avril 2009 à 11:02:24, Fujii Masao a écrit :
> Hi,
>
> On Thu, Apr 9, 2009 at 5:15 PM, fatih ozturk wrote:
> > Problem is i dont understand the difference between log_statement='all'
> > and log_statement='mod'?
>
> AFAIK, 'mod' doesn't log utility commands, such as CHECKPOINT and VACU
Le vendredi 17 avril 2009 à 09:26:41, Jaume Sabater a écrit :
> On Fri, Apr 17, 2009 at 3:00 AM, Sergio Chavarria
>
> wrote:
> > Hi, i hope someone can help me in this mailing list. Is there a way to
> > schedule databases querys with postgresql?? Ideally i would like to have
> > a database table
Le jeudi 6 août 2009 à 23:29:00, bricklen a écrit :
> Take a look at the "CSV" option of "COPY". That should do what you're
> after.
>
> http://www.postgresql.org/docs/8.4/interactive/sql-copy.html
>
You can also use pgloader, a great python tool.
--
Guillaume.
http://www.postgresqlfr.org
htt
Le vendredi 30 octobre 2009 à 02:37:04, David Lazar a écrit :
> Hi,
>
> On Linux version of pgAdmin, in an edit grid, with a boolean column, I
> could hammer the space bar key and cycle through True, False and the other
> one... whatever...
>
> With OSX version if I hit spacebar I get True... b
Le mardi 17 novembre 2009 à 07:57:41, Tena Sakai a écrit :
> Hi Tom,
>
> Many thanks for your assistance.
>
> I am on my way. Here's what I am doing:
>
> dropdb musket
> createdb musket
> pg_dump canon > canon.dump
> psql -d musket -f canon.dump
>
> I am on the 4th step. But I could a
Le mardi 17 novembre 2009 à 01:59:31, Kasia Tuszynska a écrit :
> [...]
> Question1:
> Is it expected behavior that different installers give a different outcome?
>
Yes.
> Question2 ( much more important than Q1):
> Is it possible to get an rpm build for linux that will behave like the msi
> in
Le jeudi 19 novembre 2009 à 07:01:57, Shruthi A a écrit :
> Wow! Thanks a lot! That was a great deal of help! :-)
>
> On Wed, Nov 18, 2009 at 8:41 PM, Jure Kobal wrote:
> > > -- While running the pgagent daemon, what dbname should i specify? Is
> > > it postgres or pgadmin (as the example in
>
Le mercredi 2 décembre 2009 à 07:34:09, Brian Myers a écrit :
> Hi all,
>
> I'm trying to restore an old backup (7.1.4) into a new PG database (8.4).
> There are errors with some of the RI and sequences, but those are easy to
> fix.
>
> The problem is that one table in the DB has TEXT fields in
Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit :
> Hi Scott,
>
> >> 7. we can set the privilege of user x for schema y
> >> ie. database aaa contains schema a1, a2 and a3. user xx can query from
> >> schema a1 only, user yy can query from schema a2 only?
> >
> > No, p
Le mercredi 9 décembre 2009 à 12:14:25, Bradley Kieser a écrit :
> Hi all,
>
> I have been struggling with my Posgres installation. I frequently get
>
> connection limit exceeded for non-superusers
>
> errors. I have checked the process count and it seems to be a limit of 100
> connect
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
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
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 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 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
>
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
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
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 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 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 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
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
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
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
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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: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 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 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 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 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 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 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 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 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 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 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
1 - 100 of 145 matches
Mail list logo