[ADMIN] Remote Access

2005-06-17 Thread Marcos
Hello, I have one server postgresql in my home computer, and now I have the necessity of access it of my work, the question is. How I liberate the access remote of postgresql with password? -- Thanks, Marcos José Setim Usando o M2 do Opera: http

Re: [ADMIN] Remote Access

2005-06-27 Thread Marcos
Thanks for your reply. You want to edit postgresql.conf and set listen_addresses to *. And you need to add a host or hostssl entry to pg_hba.conf allowing a connection from your office machine. Oh! Yes. I already had made this, and gave certain :o), but I can connect only with trust mode (with

[ADMIN] pg_upgrade issue

2013-06-19 Thread Marcos Cano
so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and following the instructions of the documentation i've found myself in a major issue which has overwhelmed my little knowledge. these were the steps i followed: 1)downloand and install 9.2.4, with the contrib packages. 2)init the 9.2.4 cluster

[ADMIN] PG_UPGRADE major issue

2013-06-19 Thread Marcos Cano
so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and following the instructions of the documentation i've found myself in a major issue which has overwhelmed my little knowledge. these were the steps i followed: 1)downloand and install 9.2.4, with the contrib packages. 2)init the 9.2.4 cluster

Re: [ADMIN] pg_upgrade issue

2013-06-19 Thread Marcos Cano
yes i guess is postgis... because we are using postgis in our DB but I wasn't aware On Wednesday, June 19, 2013, Bruce Momjian wrote: > On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote: > > ERROR: could not access file "$libdir/liblwgeom": No such file or &

Re: [ADMIN] PG_UPGRADE major issue

2013-06-20 Thread Marcos Cano
thanks for your reply, yes i did not have any postgis installation. i'm a little bit confused right and i really need some help.. this is my case: i have pg8.3.2 running with postgis 1.3.x, i'm willing to upgrade to pg9.2.4 using the pg_upgrade utility, now the problem is that apparently i need to

Re: [ADMIN] PG_UPGRADE major issue

2013-06-20 Thread Marcos Cano
thank you very much On Thu, Jun 20, 2013 at 11:01 AM, Burgholzer, Robert (DEQ) < robert.burghol...@deq.virginia.gov> wrote: > Marcos, > This answer might be best put over on the postGIS listserv, but I will > suggest a couple of strategies based on some differing assumptions an

[ADMIN] pg_upgrade / postgis issue

2013-06-26 Thread Marcos Cano
so my problem is that i have pg8.3 + postgis 1.3.x and i want to upgrade both of em to pg9.2.4 + postgis 2.0.4. so i've installed pg9.2.4 with postgis 2.0.4 and the server is running in a different port (5433) so both servers are up and running (not a big deal). when i try to pg_upgrade it gives

Re: [ADMIN] pg_upgrade / postgis issue

2013-06-27 Thread Marcos Cano
r developer, i'm the server admin On Thu, Jun 27, 2013 at 10:58 AM, Sergey Konoplev wrote: > (please, don't forget to put the list in CC when replying) > > On Thu, Jun 27, 2013 at 9:40 AM, Marcos Cano wrote: > > i got some errors in some databases like: > > psql

Re: [ADMIN] pg_upgrade / postgis issue

2013-07-04 Thread Marcos Cano
the perl script of postgis) within the postgres 9.2.4+postgis 2.0.4 On Wed, Jul 3, 2013 at 7:12 PM, Sergey Konoplev wrote: > On Mon, Jul 1, 2013 at 9:20 AM, Marcos Cano wrote: > > content of the file tables_using_names.txt: > > Database: dev > > public.geography_c

[ADMIN] vacuum - verbose

2002-07-11 Thread Marcos Garcia
Hi, What's the meaning of the following line when I make # vacuumdb -v -d dbname NOTICE: Pages 58094: Changed 319, Empty 0; Tup 77163: Vac 4428, Keep 0, UnUsed 2455413. Total CPU 8.84s/1.17u sec elapsed 108.12 sec. I'm specially focused on "UnUsed -> 2455413". Thanks in advance, M.P.Garcia

[ADMIN] HELP

2006-02-10 Thread Marcos de Lima Takayas
in this case, but I have not yet seen a solution for it. Can anyone please help with this problem, it is kind of critical for us. Thanks a lot in advance. Marcos Takayas DBA Embratel - Brazil ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [ADMIN] HELP

2006-02-10 Thread Marcos de Lima Takayas
rom: "Stef" <[EMAIL PROTECTED]> To: "Marcos de Lima Takayas" <[EMAIL PROTECTED]> Cc: Sent: Friday, February 10, 2006 10:54 AM Subject: Re: [ADMIN] HELP Marcos de Lima Takayas mentioned : => We had an accident with a table where all tuples where deleted. => We have

[ADMIN] data problem

2000-12-29 Thread Marcos Rogerio Nunes de Assuncao
I've have problem with postgress. "Backend message type 0x44 arrived while idle" Can You help me? thanks Marcos