On 2015-10-27 20:29, Edson Richter wrote:
> Hi!
>
> Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
> 20140911, installed using yum repository.
>
> In postgresql.conf, I do have:
>
> timezone="America/Sao_Paulo"
>
> Since DST is in place in Brazil, it is enough to
On 2015-10-28 14:09, anj patnaik wrote:
>
> Also, I want to know if anyone has found any handy cron scripts for automated
> backups to run on a daily/weekly basis? i found some on google, but interested
> to know if there are better ones.
It does a lot more but:
https://github.com/wal-e/wal-e
On 2015-10-23 08:29, Day, David wrote:
> I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can
> connect to the database via psql or pgadminIII both locally and remotely.
>
> However, all of the local apps ( 3 different ones ) that would connect to it
> are failing to
On 2015-10-18 16:37, Nicolas Paris wrote:
>
> I didn't know DBeaver, it looks great ! (I personnally have many bugs/freeze
> with pgadmin3 on ubuntu, moreover the interface is not userfriendly)
It also has the advantage of working with all the major database engines, so
you can use the same
On 2015-10-18 08:04, jwienc...@comcast.net wrote:
> Hello
>
> Is anyone aware of any tools like TOAD that are available for Postgresql?
DBeaver works will all kinds of databases, DB2, Sybase, Oracle, SQLite, MySQL
and PostgreSQL. It's written in Java and runs anywhere a JVM will:
On 2015-09-24 03:55, maxiangqian wrote:
> when I use tar to online backup ,It has an error:
>
> /bin/tar: Removing leading `/' from member names
This is not an error, more like a warning. GNU tar doesn't not store the full
path in the tar file, but a relative path, as full paths are
On 2015-08-20 07:50, Laurent Laborde wrote:
I'm wondering if anyone tried the following hot backup process, and if it
works :
pg_start_backup()
zfs snapshop
pg_stop_backup()
copy the snapshot to the backup server.
I have done this with AWS EBS snapshots, created new volumes from the
I have a csv string in a text field that is unsorted and contains duplicates.
Is there a simple way to remove these and sort the string.
E.g
2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27
Do you need to eventually load the data in Postgres?
I'd personally use python to deal with this,
On 2015-07-26 20:51, p...@arbolone.ca wrote:
After installing PostgreSQL I lost the password, how can I recover it?
Assuming you have local login configured (which is the default), you can su
to the postgres user (or whichever is configured in pg_hba.conf) and login
with psql directly without
On 2015-06-11 08:20, Geoff Winkless wrote:
On 11 June 2015 at 15:17, Marc Mamin m.ma...@intershop.de
mailto:m.ma...@intershop.dewrote:
But COUNT(*)
does have meaning - it means the number of rows.
which rows? :-)
The number of rows in the query, as well you know
On 2015-05-25 17:58, Adrian Klaver wrote:
On 05/25/2015 01:41 PM, Francisco Reyes wrote:
On multiple machines, should the MD5 be the same?
using
select rolname, rolpassword,rolcanlogin from pg_catalog.pg_authid where
rolname = 'SomeUser';
Should the MD5 be the same?
I understood that is
On 2015-05-25 17:58, Adrian Klaver wrote:
On 05/25/2015 01:41 PM, Francisco Reyes wrote:
On multiple machines, should the MD5 be the same?
using
select rolname, rolpassword,rolcanlogin from pg_catalog.pg_authid where
rolname = 'SomeUser';
Should the MD5 be the same?
I understood that is
On 2015-05-15 18:31, Scott Marlowe wrote:
On Fri, May 15, 2015 at 9:18 AM, Job j...@colliniconsulting.it wrote:
i have a table of about 10 millions of records, with the index on a string
field.
Actually is alphabetical; since queries are about 100/200 per seconds, i was
looking for a better
On 2015-05-13 07:37, Jim Mlodgenski wrote:
Yes, the talks were recorded. There was a lot of content so we are still
working on getting everything together. We hope to have them up soon.
Will you be posting on this list when they are ready?
--
http://yves.zioup.com
gpg: 4096R/32B0F416
On Wed, May 13, 2015 at 05:29:36PM -0600, Yves Dorfsman wrote:
Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
On 2015-05-13 17:56, David G. Johnston wrote:
From the documentation of SELECT INTO
The PostgreSQL usage of SELECT INTO to represent table creation
Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
Thanks.
--
http://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 9.3, is there any way to start a query, detach from the server and have the
query keep going (long query that updates tables, but nothing is returned)?
Thanks.
--
http://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
As for performance concerns, in 99% of cases code maintainability is going to
be way more important than performance microoptimization. If you're *that*
concerned about performance than plpgsql probably isn't the right answer
anyway.
Isn't one of the advantage of running on the server to
I just want to confirm that currently there is no scheduler that isn't
dependent on a crontab (like PgAgent), that could be run entirely from within
PostgreSQL only.
Anybody knows of one?
--
http://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-general mailing list
I find my plpgsql functions becomes unreadable very quickly. I want to break
them up in smaller functions.
What is the best way to organised them?
Is there any way to define functions inside functions?
When I list functions in psql, I can see them all at the same level, is there
any way to
On 2015-05-02 11:12, Melvin Davidson wrote:
AFAIK, you cannot package functions in PostgreSQL, but it is possible to
call a function from within a function.
That being said, I would seriously look at how and why you are writing your
functions
as functions that call other functions are not
Hi,
If I run checkpoint from psql, is it applied to all the databases?
What if I do it though an API? When connecting with psycopg2, I'm forced to
specify a database name, if I use dbname=postgres, and execute
checkpoint;, is it applied to all the databases?
Thanks.
--
Yves.
--
Sent via
On 2014-07-10 13:02, Guillaume Lelarge wrote:
2014-07-10 20:56 GMT+02:00 Yves Dorfsman y...@zioup.com
mailto:y...@zioup.com:
Hi,
If I run checkpoint from psql, is it applied to all the databases?
What if I do it though an API? When connecting with psycopg2, I'm forced
//postgres start
Yves.
Yves Dorfsman[EMAIL PROTECTED]
http://www.cuug.ab.ca/~dorfsmay
Fred [EMAIL PROTECTED] wrote:
How to remove a user in postgres ?
either:
dropuser username (from the command line)
or
DROP USER username; (as an SQL statement)
Yves.
Yves Dorfsman[EMAIL PROTECTED
(relations).
\dS pg_user
Will give you the structure of that table, and actually some more help.
SELECT usename, usesuper from pg_shadow;
Will give you a list of the users that are define, and indicate which one
is the super user.
Yves.
Yves Dorfsman
of
the world.
If I can't do it with postgres, I'm thinking of using mySQL for the read
only part, but I would much prefer to use postgres, since I'm using it on
the read/write side.
Thanks,
Yves.
Yves Dorfsman[EMAIL PROTECTED
.
Yves Dorfsman[EMAIL PROTECTED]
http://www.cuug.ab.ca/~dorfsmay
Is there any way to use raw devices within postgreSQL, or does it support
file system only ??
Is there any reason for not supporting raw device, or is it just a
question of not having the time to write a driver ?
Yves.
Yves Dorfsman[EMAIL PROTECTED
29 matches
Mail list logo