Como verificar o tamanho de minha base de dados PostgreSQL?
Para verificar o tamanho da Base de dados postgres utilize o seguinte comando:
select pg_size_pretty(pg_database_size('base_que_sera_consultada'));
Veja também
- Como definir ou alterar a senha do banco de dados postgreSQL?
- Como administrar minha base de dados PostgreSQL?
Atenção: verifique se o acesso remoto está liberado para sua base conforme esta página
Dados para acesso à sua base PostgreSQL:
Server: postgresqlxx.SEUDOMINIO onde xx é o número do prefixo de seu banco exemplo postgresql01.SEUDOMINIO ou postgresql02.SEUDOMINIO… ( (Você pode utilizar também o endereço ALTERNATIVO do servidor informado no e-mail de instruções.)
Port: 5432
Username: USUARIO
Password: SENHA_DO_BANCO
DB: USUARIO
Você pode utilizar uma das opções abaixo para acesso remoto a base entre outras disponíveis na internet:
– EMS SQL Manager for PostgreSQL – http://www.sqlmanager.com.br/html/sql_manager_para_postgresql.html
– pgAdmin III – http://www.pgadmin.org (Saiba como configurar clicando aqui)
– PG Explorer – http://www.pgexplorer.com
– PgAccess – http://www.pgaccess.org
– Lightining Admin for PostgreSQL and MySQL® – http://www.amsoftwaredesign.com/lightning_admin.php
Lembramos que a Locaweb não se responsabiliza pelo perfeito funcionamento das ferramentas citadas acima.
Os dados apresentados não representam as únicas soluções do mercado. As opções de acesso remoto possuem a estrita finalidade de auxiliá-lo na obtenção de informações e dados para busca de fornecedores.
Atenção!
A novas bases de dados já vem sem restrição de acesso por IP, sendo assim, não é necessário solicitar a liberação de acesso.
Veja também
Todas as bases de dados PostgreSQL dos planos de hospedagem compartilhado da Locaweb estão publicadas em um servidor Linux. Independente do cliente tiver um serviço de hospedagem na plataforma Windows ou Linux a sua base de dados esta em um servidor Linux.
Quando você ativa uma base de dados PostgreSQL em um servidor Windows o padrão do Encoding é ( Win1252 ) que é o mesmo Encoding ( Latin1 ) utilizado nos servidores Linux. Segue algumas informações sobre esta codificação em: Windows-1252
Segue uma tabela de Character suportado em uma base PostgreSQL em:Character Set Support
Veja também
- Como definir ou alterar a senha do banco de dados postgreSQL?
- Como administrar minha base de dados PostgreSQL?
Your post was both insightful and wonderfully written.
You compel ought to an staggering capability faculty to write open content play roulette wheel.
This is exactly what I needed to peruse today Tender thanks you play Texas Holdem online.
You father an astonishing capability faculty to set engaging content betting sites.
Your dispatch was not only communicative but also unquestionably inspiring play online casinos.
What an riveting interpret You from a capacity for this love cannabis oil for sale.
You’re doing great work This post is testimony of that cbdoilsiv.com/.
Every dot you ìåéä was spot-on Unforgivable analysis.
Your insights are situation on Thanks because the great read seo platform ratings.
I’m thoroughly impressed by your latest blog post. The way you’ve articulated your points is nothing short of brilliant. Your balanced approach, blending in-depth research with personal anecdotes, makes your writing not only informative but also highly relatable viagra without a prescription.
You made some clear points there. I looked on the internet for the topic and found most persons will approve with your blog.
I have not checked in here for a while because I thought it was getting boring, but the last several posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂
Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you can do with a few pics to drive the message home a little bit, but other than that, this is magnificent blog. A fantastic read. I’ll certainly be back.
Have you ever thought about adding a little bit more than just your articles? I mean, what you say is fundamental and all. Nevertheless think of if you added some great photos or videos to give your posts more, “pop”! Your content is excellent but with pics and clips, this website could definitely be one of the greatest in its niche. Wonderful blog!
This web site is known as a walk-via for the entire data you wanted about this and didn’t know who to ask. Glimpse here, and you’ll undoubtedly discover it.
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You definitely know what youre talking about, why throw away your intelligence on just posting videos to your site when you could be giving us something enlightening to read?
Hi there, just become aware of your weblog via Google, and located that it’s really informative. I’m gonna watch out for brussels. I’ll be grateful if you happen to continue this in future. A lot of people might be benefited from your writing. Cheers!
Pretty great post. I just stumbled upon your weblog and wanted to mention that I have truly loved browsing your blog posts. In any case I will be subscribing in your rss feed and I’m hoping you write once more very soon!
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik