Re: [ADMIN] ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory

2010-03-29 Thread ALEXANDER JOSE
Good morning You have to revise the base folder to create postgres when you perform the initial installation and verify the relation fallanado that I spend And it turned out he had a folder in C: \ Program Files \ PostgreSQL \ 8.2 \ data \ base folder exists the number 1, this is where the

[ADMIN] block a database

2010-04-08 Thread ALEXANDER JOSE
As I can block a database so users can not connect without affecting the other databases. Atentamente, Alexander Angel DBA 058-02128018316 _ Connect to the next generation of MSN Messenge

[ADMIN] Restore database in postgres 8.4 linux

2010-05-19 Thread ALEXANDER JOSE
I have a question, I have postgres 8.2.5 on a windows server on another machine and I have suse linux enterprise 10 postgres 8.4, you perform a backup with pgadmin 1.10 to a database and restore the database in the version of postgres 8.4 gave me many errors that could not find some functions.

[ADMIN] Restore pg_dumpall

2010-05-28 Thread ALEXANDER JOSE
Perform a backup with the following command; pg_dumpall-Upostgres and record it in a file called respaldo.sql postgres in my instance I have 22 databases, I wondered if the above command I have supported all my databases and I use another command. ___

[ADMIN] FW: Restore pg_dumpall

2010-05-28 Thread ALEXANDER JOSE
Perform a backup with the following command; pg_dumpall-Upostgres and record it in a file called respaldo.sql postgres in my instance I have 22 databases, I wondered if the above command I have supported all my databases and I use another command. Atentamente Alexander Angel Venezuela

[ADMIN] Restore DataBase

2010-06-01 Thread ALEXANDER JOSE
psql coon I'm trying to restore a database that has 60 GB in size, where there is a table with 38 million records, has raised 18 million records when the restore process fails on a syntax error, the backup was made with a file. sql as the best way I can do to restore?? Alexander Angel

[ADMIN] Postgresql for Windows 7

2010-07-27 Thread ALEXANDER JOSE
I wonder if anyone has experience in installing postgresql on windows 7 that is the most appropriate version? Atentamente Alexander Angel Venezuela _ Discover the new Windows Vista http:

[ADMIN] received fast shutdown request

2011-05-23 Thread ALEXANDER JOSE
tengo un problema la base de datos ha enviado el sigiuente mensaje por consola; LOG: received fast shutdown request LOG: aborting any active transactions I wonder what is the problem because the database shutdown services and not restart automatically. Atentamente Alexander Angel DBA pos

[ADMIN] Problem with postgres 8.2.5

2011-05-23 Thread ALEXANDER JOSE
I have a problem database sigiuente sent the message to the console; LOG: received fast shutdown request LOG: aborting any active transactions I wonder what is the problem because the database shutdown services and not restart automatically. Atentamente Alexander Angel DBA postgres Venezu

[ADMIN] Postgres 8.2.5

2011-08-03 Thread ALEXANDER JOSE
Good morning, I have a postgres database on a server v 8.2.5 windows, and I need to install the postgres version 8.2.5 on Server with Suse Linux Enterprise but does not create 860 functions, let me know if have facilities of this version, or another version of postgres successfully in operat

[ADMIN] Postgres 9 on 64 bit

2011-09-27 Thread ALEXANDER JOSE
Hi, I want to know the experience of installing postgres 9 in 64 bit, on suse enterprise linux 11 thank Alexander Angel Venezuela

[ADMIN] Postgres en Cluster

2013-02-07 Thread ALEXANDER JOSE
What may be the best strategy for working postgres in cluster, now I have two postgres servers SuSE Linux Enterprise 11, and postgres database is at version 9.0.4. Atentamente Alexander DBA venezuela

[ADMIN] Postgresql Courses

2013-04-27 Thread ALEXANDER JOSE
Hello, I work in Venezuela, and I wonder if they know of companies that dictate postgresql advanced courses in South America, including Venezuela. We need to work postgresql in high availability cluster. Alexander Angel DBA Postgresql