Re: [ADMIN] uuid extension not available

Chris "If you wish to make an apple pie from scratch, you must first invent the Universe." -- Carl Sagan -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] convert from latin1 to utf8

-admin@postgresql.org Subject: RE: [ADMIN] convert from latin1 to utf8 I needed both UTF8 and Latin-1. I accomplished this by initdb with the LOCALE set to C. That lets me create dbs "with template0 encoding='Latin-1'" as well as "encoding=UTF8," FWIW...

Re: [ADMIN] Mysql to Postgresql

ant to convert mysql to postgresql , > any free tools available?. Is it possible to convert manually. Please > guide me > > best regards > > Alfred > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: &g

[ADMIN] Mysql to Postgresql

Hi i want to convert mysql to postgresql , any free tools available?. Is it possible to convert manually. Please guide me best regards Alfred -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[ADMIN] Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

; blkio= /cgroup/blkio; } group test1 { perm { task{ uid=postgres; gid=postgres; } admin{ uid=root; gid=root; } } memory { memory.limit_in_bytes=300M; } } /etc

Re: [ADMIN] convert from latin1 to utf8

I needed both UTF8 and Latin-1. I accomplished this by initdb with the LOCALE set to C. That lets me create dbs "with template0 encoding='Latin-1'" as well as "encoding=UTF8," FWIW... Original message From: Marc Fromm Date: 10/10/2013 5:39 PM

[ADMIN] convert from latin1 to utf8

I need to convert a bunch of my databases to utf8 before I can migrate them to postgresql 8.4. Is there a command that during the pg_dumpall process the encoding can be changed from latin1 to utf8? This is the error I get when migrating the databases from 8.1 to a machine running 8.4 psql:pgdbs

Re: [ADMIN] move dbs from 8.1 to 8.4

Thursday, October 10, 2013 1:55 PM To: Marc Fromm; pgsql-admin@postgresql.org Subject: Re: [ADMIN] move dbs from 8.1 to 8.4 On 10/10/2013 01:17 PM, Marc Fromm wrote: I built a new server running centos 6.4 and postgresql 8.4. I backed up all the databases from the old server running fedora and

Re: [ADMIN] move dbs from 8.1 to 8.4

anks I am using 8.4 just because it's what gets installed with CentOS6.4. From: Steve Crawford [mailto:scrawf...@pinpointresearch.com] Sent: Thursday, October 10, 2013 1:55 PM To: Marc Fromm; pgsql-admin@postgresql.org Subject: Re: [ADMIN] move dbs from 8.1 to 8.4 On 10/10/2013 01:17 PM, Marc

Re: [ADMIN] move dbs from 8.1 to 8.4

On 10/10/2013 01:17 PM, Marc Fromm wrote: I built a new server running centos 6.4 and postgresql 8.4. I backed up all the databases from the old server running fedora and postgresql 8.1 using this script. *#!/bin/bash* *# Backup all Postgresql databases* ** *# Location of the backup logfi

Re: [ADMIN] move dbs from 8.1 to 8.4

, how do I migrate the databases with their tables and data and migrate the latin1 encoded databases? Thanks From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Marc Fromm Sent: Thursday, October 10, 2013 1:17 PM To: pgsql-admin@postgresql.org Subject

Re: [ADMIN] move dbs from 8.1 to 8.4

Can you use '-v' with pg_dumpall and output to the log file? That might help. Likely something is not right with the individual pg_dump processes that work inside the pg_dumpall. Payal Singh, OmniTi Computer Consulting Inc. Junior Database Architect, Phone: 240.646.0770 x 253 On Thu, Oct 10, 201

Re: [ADMIN] uuid extension not available

it sounds like you are missing the contrib code. if you built from source you need to go to the contrib directory and run make, make install. if you installed from a package you need to install the appropriate contrib package. reiner sent by smoke signals at great danger to my self. On 1

Re: [ADMIN] Reg. Restore

Thanks for your reply. ---> You should update to a more current minor release. Recently I updated to 9.1.5. I will do in near future. --> You need to provide more information on how you backed up, how you are restoring, and what the bottleneck seems to be. I am pg_restore using for restoring

Re: [ADMIN] Reg. Restore

Thanks for your reply. ---> You should update to 9.1.9. Recently I updated to 9.1.5. I will do in near future. --> How are you doing this restore? Is it from a dump? Are you using or could you use custom format? I am pg_restore using for restoring the backup which created using pg_dump. -

[ADMIN] move dbs from 8.1 to 8.4

I built a new server running centos 6.4 and postgresql 8.4. I backed up all the databases from the old server running fedora and postgresql 8.1 using this script. #!/bin/bash # Backup all Postgresql databases # Location of the backup logfile. logfile="/var/lib/pgsql/backups/logs/pg_back.log" #

[ADMIN] ts_vector workaround for - No more than 256 positions per lexeme

advance, Avni -- View this message in context: http://postgresql.1045698.n5.nabble.com/ts-vector-workaround-for-No-more-than-256-positions-per-lexeme-tp5774106.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin

Re: [ADMIN] uuid extension not available

ge: postgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64 (pgdg92)    Requires: libossp-uuid.so.16()(64bit)  You could try using --skip-broken to work around the problem  You could try running: rpm -Va --nofiles --nodigest       Where can I get this library from ? Thanks. ____

[ADMIN] uuid extension not available

Hi I have postgresql 9.2 installed on red hat linux 6.4 . I need to generate uuids using the uuid_generate_v4() function.   select * from pg_available_extensions does not list this extension. The only  extension that is available is plpgsql.   I find uuid libraries, libuuid.so.1 and libuuid.so.1.3

Re: [ADMIN] Random server overload

"Does the server log say anything about broken connections or client not responding?" Nope, no errors in server log, just high I/O and no free slots remaining. We are thinking of adding more RAM to the server what should speed up the queries.. -- Best regards, Viktor

Re: [ADMIN] Random server overload

DB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Random server overload

Hello, It's me again.. Log_connection inspection didn't help to find the cause, the connections come from our app-servers as usual.. Btw we have the max pool size of web application 50 connections and since we have 4 instances of application running  it makes max 200. I don't really g

Re: [ADMIN] Reg. Restore

On Tue, Oct 8, 2013 at 2:43 AM, Venakata Ramana wrote: > Thanks for your reply. > > > ---> You should update to 9.1.9. > > Recently I updated to 9.1.5. I will do in near future. > > Recently??? 9.1.5 was released more then one year ago... =/ > > --> How are you doing this restore? Is it from a du

Re: [ADMIN] postgres connections in IDLE state..

cess id? I'd use operating system tools like lsof, it provides you information related to devices, files opened... or if you want to know application information you should use java debuger like jconsole, jvisualvm. > > Regards > Jayashree > > -Original Message- > Fro

Re: [ADMIN] Reg. Restore

not enough information to give much advice.  Please read this page and start a new thread on the pgsql-performance list: http://wiki.postgresql.org/wiki/SlowQueryQuestions -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin ma

Re: [ADMIN] Reg. Restore

On Mon, Oct 7, 2013 at 9:03 AM, Venakata Ramana wrote: > Hi, > > I am using postgresql 9.1.5. on windows Xp. > > You should update to 9.1.9. I am facing two problems: > > 1. Restore of DB is very slow. > How to improve the speed of Restore? > > How are you doing this restore? Is it from a du

[ADMIN] Reg. Restore

Hi, I am using postgresql 9.1.5. on windows Xp. I am facing two problems: 1. Restore of DB is very slow. How to improve the speed of Restore? 2. Without indexes, retrieving from table is fast? After creating an index on that table, then the retrieval become slow. plz prove any solution

Re: [ADMIN] pg_stat_activity - proc id

we set the application_name to some unique id such as client process ID or processid#threadid when client Start the new session. jov 在 2013-10-7 上午10:39，"Rajagopalan, Jayashree" 写道： > Hi: > > ** ** > > How to correlate the procpid in pg_stat activity table to any application > process? I nee

Re: [ADMIN] pg_stat_activity - proc id

888-1979 gray...@gmail.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] pg_stat_activity - proc id

Hi: How to correlate the procpid in pg_stat activity table to any application process? I need to track down some connections to the queries/application threads. Please help!! Regards Jayashree

Re: [ADMIN] How to track down locks held by recovery process on a slave?

ch any pg_class.oid. > > Any idea How could I find out which relations are locked by the recovering > process? > > > Thanks in advance, > A.A. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] How to track down locks held by recovery process on a slave?

Hi there, I am using a postgres 9.2 slave for some reports and I noticed that sometimes they are held up because certain activity on the master like vacuums can affect long queries on a slave . Looking at pg_locks view , I can see that the recovering process on the slave is holding some AccessExc

Re: [ADMIN] ERROR: could not open file "base/125542/12631" Corruption?

Update - someone unleashed a 'cleanup script' yesterday via puppet to multiple hosts and greedily deleted files that had not been modified in 15 days. This is the most likely culprit so mystery basically solved. Thankfully this is in QA, whew! It would be interesting to still know if there are w

Re: [ADMIN] ERROR: could not open file "base/125542/12631" Corruption?

http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] ERROR: could not open file "base/125542/12631" Corruption?

El 04/10/2013 14:10, Mike Broers escribió: > Strange, this is happening in a totally different environment now too. > The only thing these two environments share is a SAN, but I wouldnt > think something going on at the SAN level would make files disappear. > Any suggestions are greatly apprecia

Re: [ADMIN] ERROR: could not open file "base/125542/12631" Corruption?

Strange, this is happening in a totally different environment now too. The only thing these two environments share is a SAN, but I wouldnt think something going on at the SAN level would make files disappear. Any suggestions are greatly appreciated. On Fri, Oct 4, 2013 at 9:40 AM, Mike Broers

Re: [ADMIN] ERROR: could not open file "base/125542/12631" Corruption?

El 04/10/2013 11:40, Mike Broers escribió: > Hello, our postgresql 9.2.4 qa database (thankfully its just qa) seems > to be hosed. > > Starting at around 3:39am last night I started seeing errors about > missing files and now I cannot run a pgdump or a vacuum without it > complaining about files

[ADMIN] ERROR: could not open file "base/125542/12631" Corruption?

Hello, our postgresql 9.2.4 qa database (thankfully its just qa) seems to be hosed. Starting at around 3:39am last night I started seeing errors about missing files and now I cannot run a pgdump or a vacuum without it complaining about files that it cannot find with errors like this: ERROR: could

Re: [ADMIN] partitioning system tables

way to improve performance of the DDL > operations? You can't do that. I think the problem you should address is why there are so many rows in a catalog table. 10 million is an awful lot. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make chang

Re: [ADMIN] postgres connections in IDLE state..

Thanks. But what is the process id that is attached to the connection? Can I track down or debug/ get more information related to that process id? Regards Jayashree -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of David

Re: [ADMIN] postgres connections in IDLE state..

.n5.nabble.com/postgres-connections-in-IDLE-state-tp5773232p5773234.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] postgres connections in IDLE state..

Hi all: Our application uses Jboss-hibernate with Postgres as the backend. I'm seeing intermittently - the DB connections getting stale - and not getting returned to the Hibernate session pool. Some of the connections are as old as 9 days. The pg_stat shows the connection as IDLE in the DB. da

Re: [ADMIN] Database replication to 50-80 nodes

need so many standbys? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.

Re: [ADMIN] Database replication to 50-80 nodes

y slaves for? -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 gray...@gmail.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscr

Re: [ADMIN] pgAdmin forgets password on "could not connect to server" error

onvenient when using a long pass-phrase as it requires me > to lookup the password and re-enter it when I can again connect to the > server. > What has that to do with Postgres? It's a pgadmin3 question. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) T

Re: [ADMIN] partitioning system tables

anism that would not be readily partitioned. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/partitioning-system-tables-tp5773152p5773155.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsq

[ADMIN] partitioning system tables

Hello, When postgresql system tables, (tables in pg_catalog) reach size of 10mil rows, it will slow down some DDL operations, which insert, update or delete data from pg_* tables. Is it possible to partition the system tables or is there some other way to improve performance of the DDL operations?

Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?

Do keep in mind that querying across databases generally garners really poor performance, and can bring your application to its knees with astonishing speed. From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] on behalf of Albe

Re: [ADMIN] Random server overload

t if they all become active at one time, you can have a seemingly-random server overload. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

ked around by moving to 64-bit. Did unfortunately not have time to look at the underlying issue. -- Sergey Klochkov kloch...@iqbuzz.ru -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Random server overload

> -Original Message- > From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- > ow...@postgresql.org] On Behalf Of Viktor > Sent: Wednesday, October 02, 2013 4:12 AM > To: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Random server overload > > On 10/1/2

[ADMIN] Database replication to 50-80 nodes

Can I you database Master-Slave replication on cluster with 50-80 nodes. Database is small (configuration), changed rarely. If there any problems with such nodes count.

Re: [ADMIN] Random server overload

ket later with the results. Thank you all! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?

s in pgdb01 database, I cannot select > from it using the DB > link. You have to connect to a database to query its data. Rather than defining a database link to database "postgres", define two links, one for "pgdb01" and one for "pgdb02". Yours, Laurenz Albe

Re: [ADMIN] [SQL] DB link from postgres to Oracle; how to query Dbname.tablename?

preceding 3 lines from PG_LINK;* > > I tried dbname.tablename syntax, but it didn't work! BTW, all my tables > belong to public schema. > > Does anyone with DB link expertise try to answer my question? > > Thanks, > Bhanu M. Gandikota > Mobile: (415) 420-7740 &g

[ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?

415) 420-7740 ____ From: Alejandro Brust To: pgsql-admin@postgresql.org Sent: Tuesday, October 1, 2013 12:30 PM Subject: Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 3 large objects Did U perform  any vacuumdb / re

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

d, lomacl FROM pg_largeobject_metadata > > returns 3 rows, which are then looped over? > > I ran into a similar issue a few years ago with a client using a > 32-bit version of pg_dump, and got it worked around by moving to > 64-bit. Did unfortunately not have time to look at the underlying > issue. > > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] pg_archivecleanup not cleaning up ?

Running Postgres 9.2.4 on centos 6 We have a backup script that runs twice weekly. At the end of the script it executes a pg_archivecleanup to remove the old WAL files no longer needed. Most of the time this runs as expected. But for some reason, it does not cleanup ALL of the old wal files. I n

[ADMIN] pgAdmin forgets password on "could not connect to server" error

Would it be possible to prevent the system from forgetting the stored password when pgAdmin fails to connect in a future release or have an option that would prevent forgetting of passwords? I use pgAdmin 1.16 or 1.18 to connect to our database and use the store password option. If postgres is no

Re: [ADMIN] Random server overload

the connections come from. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Random server overload

Best regards -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Random server overload

> -Original Message- > From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- > ow...@postgresql.org] On Behalf Of Viktor > Sent: Tuesday, October 01, 2013 9:19 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Random server overload > > Hello, > >

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

time to look at the underlying issue. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

On Tue, Oct 1, 2013 at 4:01 AM, Giuseppe Broccolo < giuseppe.brocc...@2ndquadrant.it> wrote: > Maybe you can performe your database changing some parameters properly: > > max_connections = 500 # (change requires restart) >> > Set it to 100, the highest value supported by PostgreS

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

it up to 4800MB checkpoint_segments = 70# in logfile segments, min 1, 16MB each effective_cache_size = 5MB Given RAM 96GB, you could set it up to 80GB Hope it can help. Giuseppe. -- Sergey Klochkov kloch...@iqbuzz.ru -- Sent via pgsql-admin mailing list (pgsql-admin@pos

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

rant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

time formatting default_text_search_config = 'pg_catalog.russian' -- Sergey Klochkov kloch...@iqbuzz.ru <mailto:kloch...@iqbuzz.ru> -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org <mailto:pgsql-admin@postgresql.org>) To make

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

lc_time = 'ru_RU.UTF-8' # locale for time formatting default_text_search_config = 'pg_catalog.russian' -- Sergey Klochkov kloch...@iqbuzz.ru <mailto:kloch...@iqbuzz.ru> -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

y = 'ru_RU.UTF-8' # locale for monetary > formatting > lc_numeric = 'ru_RU.UTF-8' # locale for number > formatting > lc_time = 'ru_RU.UTF-8' # locale for time > formatting > default_text_search_config = 'pg_catalog.russian' > > -- > Sergey Klochkov > kloch...@iqbuzz.ru > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin> >

[ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

' # locale for monetary formatting lc_numeric = 'ru_RU.UTF-8' # locale for number formatting lc_time = 'ru_RU.UTF-8' # locale for time formatting default_text_search_config = 'pg_catalog.russian' -- Sergey Klochkov kloch..

[ADMIN] openclinica

I cant understand why I am not able to access and open my  openclinica webpage, . So what do I do. I have installed and downloaded java- tomcat  and post in these versions below ,  can you suggest other programs or even third parties 7z465.exe 25-Oct-2011 16:14 918K apache-tomcat-6.0.32

Re: [ADMIN] pd_dump server mismatch error

on > pg_dump (PostgreSQL) 9.2.4 > > How can I find the package name for the older version? This: rpm -qf $(which pg_dump) should show the package which the pg_dump binary in your default path belongs to. Regards Ian Barwick -- Sent via pgsql-admin mailing list (pgsql-admin@postgr

Re: [ADMIN] pd_dump server mismatch error

older version?  Thanks! Thara. From: Craig James To: Thara Vadakkeveedu Sent: Wednesday, September 25, 2013 5:32 PM Subject: Re: [ADMIN] pd_dump server mismatch error On Wed, Sep 25, 2013 at 2:15 PM, Thara Vadakkeveedu wrote: Hi >I did not inst

Fw: [ADMIN] pd_dump server mismatch error

Hi, I found pg_dump under /usr/pgsql-9.2/bin/ and /usr/bin, but both of them show version as 8.4.13. # su - postgres -bash-4.1$ cd /usr/pgsql-9.2/bin -bash-4.1$ pg_dump --version pg_dump (PostgreSQL) 8.4.13 -bash-4.1$ cd /usr/bin -bash-4.1$ pg_dump --version pg_dump (PostgreSQL) 8.4.13 How can

Re: [ADMIN] connecting to the database from pgadmin client

he statements don't get executed at all. Is this just a copy/paste error? Could you copy the complete session (what exactly you typed and what response you got)? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] pd_dump server mismatch error

y the result like the 9.2 one -- Original -- From: "Thara Vadakkeveedu";; Date: Thu, Sep 26, 2013 05:15 AM To: "alejand...@pasteleros.org.ar"; "pgsql-admin@postgresql.org"; Subject: Re: [ADMIN] pd_dump server mismatch error

Re: [ADMIN] pd_dump server mismatch error

? Thanks, TG From: Alejandro Brust To: pgsql-admin@postgresql.org Sent: Wednesday, September 25, 2013 3:47 PM Subject: Re: [ADMIN] pd_dump server mismatch error Hello, first excuse my English U cant do a backup whit a Client minor version than the server

Re: [ADMIN] pd_dump server mismatch error

netll...@gmail.com LlamaLand https://netllama.linux-sxs.org -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] pd_dump server mismatch error

Hello, first excuse my English U cant do a backup whit a Client minor version than the server U must have same version to do the backup, so U need upgrade your client (pg_dump 8.4.13) to at least 9.2.4 See U El 25/09/2013 15:55, Thara Vadakkeveedu escribió: > > Hi > I wanted to take a backup of

[ADMIN] pd_dump server mismatch error

Hi I wanted to take a backup of my database. pg_dump throws a server mismatch version error # cd backups # su - postgres -bash-4.1$ pg_dump mydb > mydbfile pg_dump: server version: 9.2.4; pg_dump version: 8.4.13 pg_dump: aborting because of server version mismatch This is a fresh install of po

Re: [ADMIN] connecting to the database from pgadmin client

s from the pgadmin client. Thanks TG From: Thara Vadakkeveedu To: Albe Laurenz ; "pgsql-admin@postgresql.org" Sent: Tuesday, September 24, 2013 8:37 PM Subject: connecting to the database from pgadmin client Hi I am trying to connect to the databa

[ADMIN] connecting to the database from pgadmin client

Hi I am trying to connect to the database on a linux server from pgadmin on my windows desktop. I see "Error connecting to the server: Fatal: password authentication failed for user "postgres" I specified my linux server name for the host port : 5432 Maintenance DB : postgres username:postgres

Re: [ADMIN] accidentally deleted data directory

Thank you!   I deleted data directory again and then ran initdb. This time service started successfully. TG   From: Albe Laurenz To: Thara Vadakkeveedu ; "pgsql-admin@postgresql.org" Sent: Tuesday, September 24, 2013 10:11 AM Subject: Re: [ADMIN] ac

Re: [ADMIN] accidentally deleted data directory

Thara Vadakkeveedu wrote: > Do I need to run pg_resetxlog to fix the corrupted pg_control file issue? No, since you don't mind starting afresh, just delete the data directory and run initdb. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

Re: [ADMIN] accidentally deleted data directory

Do I need to run pg_resetxlog to fix the corrupted pg_control file issue?   I can't find it in my 9.2 installation... thanks TG From: Thara Vadakkeveedu To: Thara Vadakkeveedu ; Albe Laurenz ; "pgsql-admin@postgresql.org" Sent: Tuesday, Sep

Re: [ADMIN] accidentally deleted data directory

_ From: Thara Vadakkeveedu To: Albe Laurenz ; "pgsql-admin@postgresql.org" Sent: Tuesday, September 24, 2013 9:47 AM Subject: Re: [ADMIN] accidentally deleted data directory Here are the settings in the postgresql.conf file:   I remember turning on logging to troubleshoot

Re: [ADMIN] accidentally deleted data directory

= 'postgresql-%a.log'  log_truncate_on_rotation=on log_rotation_age = 1d   log_rotation_size = 0   I installed postges from an rpm file (pgdg-redhat92-9.2-7.noarch.rpm) using yum install. Thanks, thara. From: Albe Laurenz To: Thara Vadakkeveedu

Re: [ADMIN] accidentally deleted data directory

if that would solve the problem. > Where can I find the uninstaller ? How did you install PostgreSQL? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] accidentally deleted data directory

If pgstartup.log is empty that points at an issue with the configuration file. From memory, when you do an initdb it recreates the configuration files in the /var/lib/pg... directory. I would look at the main control file and the pg_hba.conf and try to start the database passing it the name of the

[ADMIN] accidentally deleted data directory

  See if there are processes running for user "postgres" that look like database processes and kill them.   Then try again.   What exactly is the error message?   Yours, Laurenz Albe     Hi     ps –edf shows no postgres processes: -bash-4.1$ ps -edf | grep postgres root  6412  6249  0 18:22 pts

Re: [ADMIN] Script timeout

sure that time out will be reset at the end of the script such as > > SET statement_timeout 1000 > SELECT pg_sleep(2); > > trowhs exception > > > After that > > SELECT pg_sleep(2); > > wouldn't throw exception. > > > Can you help me to solve this i

Re: [ADMIN] accidentally deleted data directory

to run these commands (tried one at a > time) > but it said address in use > there are no processes running on 5432. > > How can I start postgres service? See if there are processes running for user "postgres" that look like database processes and kill them. Then try ag

[ADMIN] accidentally deleted data directory

Hi I am new to postgresql. I have postgresql 9.2 installed on Red hat linux 6.4 I accidentally deleted data directory this morning (/var/lib/postgresql/9.2/data)   I tried to start posgresql 9.2 service service postgresql9.2 start   I got a amessage to initialize the db first.   so I ran service p

Re: [ADMIN] upgrades and streaming replication

On Tue, Sep 10, 2013 at 10:13 PM, Charles Sprickman wrote: > I just wanted to check if there are any updates on the preferred way to > upgrade a group of servers that are using streaming replication with > minimal downtime. > > * No good options to speed up the slave copy - rsync will either use

Re: [ADMIN] Dumping a database that is not accepting commands?

hat direction a little at a time and watch the behavior.  I do think that periodic VACUUM ANALYZE statements (weekly?) of the database might be a good supplement to the autovacuum jobs, especially if you have a time when load tends to be lower to schedule that in. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Dumping a database that is not accepting commands?

. I'll check to see if it's possible to copy to a separate set of drives. > If you know at the time a row is added what group it will be in for > deletion, it might pay to move to partitioning, so that a group of > rows could be deleted pretty much as fast as you can drop a table

Re: [ADMIN] Catch exceptions outside function

x27;ve personally experienced, it would be nice to be able to suppress the warning explicitly (but just that specific one) - but alas that is not currently possible that I am aware. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Catch-exceptions-outside-functio

Re: [ADMIN] Catch exceptions outside function

Thanks Igor, this is a sufficient idea to take into account for upgrading to 9.x release. Thanks again. Roberto - Messaggio originale - Da: "Igor Neyman" A: "Roberto Grandi" , pgsql-admin@postgresql.org Inviato: Mercoledì, 18 settembre 2013 15:37:12 Oggetto:

Re: [ADMIN] Catch exceptions outside function

tion, which must eventually be committed or rolled back... -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Catch exceptions outside function

> -Original Message- > From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- > ow...@postgresql.org] On Behalf Of Roberto Grandi > Sent: Wednesday, September 18, 2013 6:17 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Catch exceptions outside function >

  1   2   3   4   5   6   7   8   9   10   >